Re: finding and removing a constraint... - Mailing list pgsql-general

From Stephan Szabo
Subject Re: finding and removing a constraint...
Date
Msg-id Pine.BSF.4.21.0103201335540.30635-100000@megazone23.bigpanda.com
Whole thread Raw
In response to finding and removing a constraint...  ("chris markiewicz" <cmarkiew@commnav.com>)
List pgsql-general
On Tue, 20 Mar 2001, chris markiewicz wrote:

> hello
>
> i am trying to remove a foreign key that i placed on a database.  what is
> the easiest way to find/delete the constraint?

The constraint will generate three triggers in pg_trigger.  You can find
the correct triggers by looking at the trigger arguments and then you
should be able to drop those triggers (note: one of the triggers is on the
referencing table, the other two are on the referenced table.)


pgsql-general by date:

Previous
From: "chris markiewicz"
Date:
Subject: RE: finding and removing a constraint...
Next
From: Stephan Szabo
Date:
Subject: Re: RE: finding and removing a constraint...