ohp@pyrenet.fr 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