| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Nathan Barnett <nbarnett(at)cellularphones(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Removing constraints |
| Date: | 2000-11-13 16:47:07 |
| Message-ID: | Pine.BSF.4.21.0011130845220.63528-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)bigpanda(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wade D. Oberpriller | 2000-11-13 16:50:02 | PL/Perl and gcc |
| Previous Message | Stephan Szabo | 2000-11-13 16:42:28 | Re: How do I list foreign key info/relation |