On 2 Mar 2002 at 10:19, Dan Langille wrote: > CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "ports" > FROM "categories" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE > PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'ports', 'categories', > 'UNSPECIFIED', 'category_id', 'id'); > > CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER INSERT OR UPDATE ON "ports" > FROM "categories" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE > PROCEDURE "RI_FKey_check_ins" ('<unnamed>', 'ports', 'categories', > 'UNSPECIFIED', 'category_id', 'id');
How is an unnamed trigger deleted? During a dump, I can find information such as this: -- -- TOC Entry ID 211 (OID 998200) -- -- Name: "RI_ConstraintTrigger_998199" Type: TRIGGER Owner: dan -- How is that information useful to this situation? -- Dan Langille The FreeBSD Diary - http://freebsddiary.org/ - practical examples ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster