|
hi ! I have running postgres 8.3.1 and a dump file from postgers 7.2 :-P , but when i tried to restore the dump i have the next message: (by the way i made the dump file using pg_dump of postgresql 8.3) CREATE CONSTRAINT TRIGGER "valida_ent_a_sal" AFTER DELETE ON "ent_a" INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('valida_ent_a_sal', 'sal_d', 'ent_a', 'FULL', 'tagname_ed', 'tagname_ea'); psql:lostriggers:10: NOTICE: ignoring incomplete trigger group for constraint "valida_ent_a_sal" FOREIGN KEY sal_d(tagname_ed) REFERENCES ent_a(tagname_ea) DETAIL: Found referenced table's DELETE trigger. CREATE TRIGGER and this: CREATE CONSTRAINT TRIGGER "<unnamed>" AFTER UPDATE ON "scenes" FROM "scenes_sub" INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('<unnamed>', 'scenes_sub', 'scenes', 'UNSPECIFIED', 'scene', 'scene', 'tag', 'tag'); psql:lostriggers:965: NOTICE: ignoring incomplete trigger group for constraint "<unnamed>" FOREIGN KEY scenes_sub(scene,tag) REFERENCES scenes(scene,tag) DETAIL: Found referenced table's UPDATE trigger. CREATE TRIGGER why some triggers are unnamed??? Which is the best way to solve this???? searching on google found that i must create foreign keys, but i don't know if is enough with the creation of the foreign key or if i must create the foreign key and the constraint too. there is an 'automagic' way to convert a constraint into a foreign key ;-) thanks! |
