Re: dropping foreign keys

I tried that, but it didn't work. I need to drop trigger <name> on
<table>. I got the name from the pg_triggers table, but apparently they
are not associated with any table.

On Wed, 12 Dec 2001, Stephan Szabo wrote:

>
> On Wed, 12 Dec 2001, Joseph Shraibman wrote:
>
> > OK I asked this a while ago but I'll try again. Is there any way to get rid of a foreign
> > key? Deleting the entry from pg_trigger causes the database to throw errors right and left.
> >
> > I'm using 7.1.3
>
> You should use drop trigger (For all 3 triggers - remember to quote the
> name too, because it's mixed case) rather than deleting directly from
> pg_trigger.
>
> If you're already in the state where pg_class has the wrong number of
> triggers, you should probably be able to correct this using a varient
> of the reenable triggers code pg_dump gives for data only dumps.
>