Re: should I worry? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: should I worry?
Date
Msg-id 3068.1194139280@sss.pgh.pa.us
Whole thread Raw
In response to Re: should I worry?  (ohp@pyrenet.fr)
Responses Re: should I worry?
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Jörg Beyer
Date:
Subject: Re: building 8.3beta2 w/ 'make check' consumes A LOT of disk space
Next
From: Tom Lane
Date:
Subject: Profiling vs autovacuum (was Re: building 8.3beta2 w/ 'make check' consumes A LOT of disk space)