<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body bgcolor="#ffffff" text="#000000">
<font face="Droid Sans">hi !<br>
<br>
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:<br>
(by the way i made the dump file using pg_dump of postgresql 8.3)<br>
<br>
<br>
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');
<br>
<br>
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)
<br>
<br>
DETAIL: Found referenced table's DELETE trigger.
<br>
<br>
CREATE TRIGGER
<br>
<br>
and this:<br>
<br>
<br>
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');
<br>
<br>
psql:lostriggers:965: NOTICE: ignoring incomplete trigger group for
constraint "<unnamed>" FOREIGN KEY scenes_sub(scene,tag)
REFERENCES scenes(scene,tag)
<br>
<br>
DETAIL: Found referenced table's UPDATE trigger.
<br>
CREATE TRIGGER
<br>
<br>
<br>
why some triggers are unnamed???<br>
<br>
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.<br>
<br>
there is an 'automagic' way to convert a constraint into a foreign
key ;-)<br>
<br>
<br>
thanks!<br>
<br>
</font>
</body>
</html>