You should be able remove the fk constraint by dropping the three
associated triggers in pg_trigger. You can find the correct ones
by look at the tgargs column if you didn't name the constraint.
Stephan Szabo
sszabo@bigpanda.com
On Mon, 13 Nov 2000, Nathan Barnett wrote:
> There is a constraint on my database that was created as part of a foreign
> key. When I dropped the foreign key index, the constraint still remained
> behind. How can I delete this constraint? It is unnamed and I figure I
> need to remove some stuff from the system tables, but I don't know which
> ones or what to delete. I'm using PostgreSQL v7.0.2. I looked through the
> user guides, but couldn't find this info there.