From: | Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> |
---|---|
To: | tibor <tiborh(at)mail(dot)datanet(dot)hu> |
Cc: | PostreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How can I delete a primary or foreign key? |
Date: | 2004-02-20 17:00:03 |
Message-ID: | 20040220085639.K84463@megazone.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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";
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2004-02-20 17:02:16 | Re: PHP + Postgres: More than 1000 postmasters produce 70.000 context switches |
Previous Message | Joshua D. Drake | 2004-02-20 16:53:59 | Re: How can I delete a primary or foreign key? |