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 16:04:38 |
Message-ID: | 200402201704.38773@newid |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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;
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
From | Date | Subject | |
---|---|---|---|
Next Message | tibor | 2004-02-20 16:27:14 | Re: How can I delete a primary or foreign key? |
Previous Message | scott.marlowe | 2004-02-20 15:56:06 | Re: How can I delete a primary or foreign key? |