Drop Foreign Key - Mailing list pgsql-general

From Gregory Wood
Subject Drop Foreign Key
Date
Msg-id 029801c1aa8c$73cea370$7889ffcc@comstock.com
Whole thread Raw
Responses Re: Drop Foreign Key  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
I'd like to drop a foreign key constraint on a table. I know there are a
number of triggers created by a FK, but how many, how do I find them to
delete them, and what other gotchas might I find when removing the
constaint(s)?

It looks like there is an INSERT/UPDATE trigger on the main table, and two
more on the table it's keyed into (one UPDATE, one DELETE)? If this is true,
can I just delete those three triggers and be done with it?

Thanks in advance,
Greg


pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: unique & update
Next
From: Milos Prudek
Date:
Subject: index does not improve performance