| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | chris markiewicz <cmarkiew(at)commnav(dot)com> |
| Cc: | "'PostgreSQL-general'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: finding and removing a constraint... |
| Date: | 2001-03-20 21:38:22 |
| Message-ID: | Pine.BSF.4.21.0103201335540.30635-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-announce 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.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-03-20 21:41:22 | Re: RE: finding and removing a constraint... |
| Previous Message | chris markiewicz | 2001-03-20 21:19:42 | RE: finding and removing a constraint... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2001-03-20 21:41:22 | Re: RE: finding and removing a constraint... |
| Previous Message | Oliver Elphick | 2001-03-20 21:28:47 | Re: Special characters |