On Tue, 23 Oct 2001, Joseph Shraibman wrote:
> I have to drop a froeign key from one of my tables. The problem is that I have another
> table that has a foreign key on the first one, so I can't do the select to temp-table
> thing and move it back.
>
> Is there any way I can remove it by mucking with pg's internal tables?
Yeah. All you should need to do is remove the three triggers that
were created for the constraint (1 on the fk table, 2 on the pk table).
You can find them in pg_trigger and you'll need to double quote the
names for the drop trigger statements because they're mixed case.