Re: CONSTRAINT

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Marcelo Pereira <gandalf(at)sum(dot)desktop(dot)com(dot)br>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: CONSTRAINT
Date: 2002-02-27 17:32:05
Message-ID: 20020227093044.C3813-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

  • CONSTRAINT at 2002-02-27 14:25:09 from Marcelo Pereira

Browse pgsql-general by date

  From Date Subject
Next Message Bart Callear 2002-02-27 18:10:40 Re: Mysql - not again
Previous Message Mitrofanov Maxim 2002-02-27 17:09:41 Can be two different sequences with one name ?