Re: CONSTRAINT - Mailing list pgsql-general

From Stephan Szabo
Subject Re: CONSTRAINT
Date
Msg-id 20020227093044.C3813-100000@megazone23.bigpanda.com
Whole thread Raw
In response to CONSTRAINT  (Marcelo Pereira <gandalf@sum.desktop.com.br>)
List pgsql-general
On Wed, 27 Feb 2002, Marcelo Pereira wrote:

> Hello All,
>
> Is there any way I could drop a CONSTRAINT (foreign key) ?

In 7.2 you should be able to use ALTER TABLE DROP CONSTRAINT
to drop the constraint by the name you gave it.  Otherwise
you can remove the triggers that implement the constraint.  There's
more info on techdocs.postgresql.org that go into the details
of the triggers which will let you find them.



pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: atomicity
Next
From: "Bart Callear"
Date:
Subject: Re: Mysql - not again