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]