Re: How can I delete a primary or foreign key? - Mailing list pgsql-general

From Stephan Szabo
Subject Re: How can I delete a primary or foreign key?
Date
Msg-id 20040220085639.K84463@megazone.bigpanda.com
Whole thread Raw
In response to Re: How can I delete a primary or foreign key?  (tibor <tiborh@mail.datanet.hu>)
Responses Re: How can I delete a primary or foreign key?
List pgsql-general
On Fri, 20 Feb 2004, tibor wrote:

> I forgot to mention that I have tried numerous variations.
> The one quoted in the original mail was from "The Complete Reference" series.
> I've also tried the one that the \h command suggests:
>
> ALTER TABLE PARENTS DROP CONSTRAINT FOREIGN KEY (TYPE) CASCADE;

\h shows me
ALTER TABLE [ ONLY ] name [ * ]
    DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]

constraint_name isn't something like: FOREIGN KEY ...
it's the name given to the constraint (preferably at add time with the
CONSTRAINT constraint_name clause otherwise it's given an arbitrary name).

If you use \d tablename
You should see something like:
Foreign-key constraints:
    "$1" FOREIGN KEY (b) REFERENCES a(a)

And the drop would look like
ALTER TABLE tablename DROP CONSTRAINT "$1";


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: How can I delete a primary or foreign key?
Next
From: Richard Huxton
Date:
Subject: Re: PHP + Postgres: More than 1000 postmasters produce 70.000 context switches