Horton

Re: should I worry?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: ohp@pyrenet.fr
Cc: pgsql-hackers@postgresql.org
Date: 2007-11-05T13:31:39Z
Lists: pgsql-hackers 
ohp@pyrenet.fr writes:
> On Sun, 4 Nov 2007, Tom Lane wrote:
>> So you have a *bunch* of partially broken FK constraints in that source
>> database.

> I just talk to my customer and he/we'll make a big batch deleting and
> recreating all foreign keys on 8.2.5.
> The question is, how do we get rid of those useless <unamed> triggers?

DROP TRIGGER should be fine.

			regards, tom lane