Re: How do I remove a foreign key constraint?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Bryan (Mailing Lists)" <bryan_lists(at)netmeme(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How do I remove a foreign key constraint?
Date: 2000-12-09 00:03:52
Message-ID: Pine.BSF.4.21.0012081602470.10987-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I believe you should be able to use DROP TRIGGER to drop the triggers
once you have their trigger name from pg_trigger.

On Fri, 8 Dec 2000, Bryan (Mailing Lists) wrote:

> I need to remove a FOREIGN KEY constraint; I take it that a foreign key
> constraint is implemented by way of three CONSTRAINT TRIGGERS; however, I
> can find no way to remove or drop a CONSTRAINT TRIGGER. Can someone please
> point me in the right direction?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-09 00:07:29 Re: Help interpreting the output of EXPLAIN
Previous Message Joel Burton 2000-12-08 23:29:15 Re: PL/pgSQL compatibility?