Search Postgresql Archives

NOTICE: ignoring incomplete trigger group for constraint

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux