Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I remove a foreign key constraint? - Mailing list pgsql-general

From Tom Lane
Subject Re: How do I remove a foreign key constraint?
Date
Msg-id 9297.976320530@sss.pgh.pa.us
Whole thread Raw
In response to How do I remove a foreign key constraint?  ("Bryan \(Mailing Lists\)" <bryan_lists@netmeme.org>)
List pgsql-general
Tree view 
"Bryan \(Mailing Lists\)" <bryan_lists@netmeme.org> writes:
> 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.

Doesn't a regular DROP TRIGGER work?  (I dunno, I haven't tried it.)

            regards, tom lane

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How do I remove a foreign key constraint?
Next
From: Tom Lane
Date:
Subject: Re: Help interpreting the output of EXPLAIN