[EMAIL PROTECTED] writes: > Is there a query I can use to know all the unamed trigger, delete them and > recreate with the right sentence?
I've applied a patch that should persuade the backend to convert the old CREATE CONSTRAINT TRIGGER commands into proper foreign-key constraints. I'd suggest applying the patch and re-loading the dump instead of trying to fix things manually. http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/trigger.c.diff?r1=1.219;r2=1.220 regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster