Re: should I worry?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ohp(at)pyrenet(dot)fr
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, pgsql-hackers list <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: should I worry?
Date: 2007-11-04 01:21:20
Message-ID: 3068.1194139280@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

ohp(at)pyrenet(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2007-11-04 02:35:20 "bad key in cancel request"
Previous Message J=?ISO-8859-1?B?9g==?=rg Beyer 2007-11-03 23:09:49 Re: building 8.3beta2 w/ 'make check' consumes A LOT of disk space