From: | tibor <tiborh(at)mail(dot)datanet(dot)hu> |
---|---|
To: | PostreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How can I delete a primary or foreign key? |
Date: | 2004-02-20 17:03:12 |
Message-ID: | 200402201803.12519@newid |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
you are right. the correct version is:
ALTER TABLE name_of_table
DROP CONSTRAINT constraint_name [ RESTRICT | CASCADE ]
On Friday 20 Feb 2004 17:53, you wrote:
> 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;
>
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> You are forgetting the name of the constraint.
>
> Sincerely,
>
> Joshua D. Drake
>
> > but all I got was:
> >
> > ERROR: syntax error at or near "foreign" at character 37
> >
> > the DROP CONSTRAINT clause doesn't recognise either PRIMARY or FOREIGN
> > KEY option. (not implemented, I guess)
> >
> > On Friday 20 Feb 2004 16:42, you wrote:
> >>On Fri, 20 Feb 2004, Tibor wrote:
> >>>I am using PostgreSQL 7.4.1 (only through psql)
> >>>I know, that the command
> >>>
> >>>ALTER TABLE OFFICES
> >>> DROP PRIMARY KEY (CITY);
> >>>
> >>>and its foreign key equivalent:
> >>>
> >>>ALTER TABLE SALESREPS
> >>> DROP CONSTRAINT
> >>>FOREIGN KEY (REP_OFFICE)
> >>> REFERENCES OFFICES;
> >>>
> >>>don't work in PostgreSQL because they are not implemented. However,
> >>> isn't there another way of removing them?
> >>
> >>That's not the correct syntax for ALTER TABLE ... DROP CONSTRAINT.
> >>
> >>ALTER TABLE tablename DROP CONSTRAINT constraint_name [RESTRICT |
> >> CASCADE]
--
Tibor Harcsa
From | Date | Subject | |
---|---|---|---|
Next Message | tibor | 2004-02-20 17:06:44 | Re: How can I delete a primary or foreign key? |
Previous Message | Richard Huxton | 2004-02-20 17:02:16 | Re: PHP + Postgres: More than 1000 postmasters produce 70.000 context switches |