Re: Bug?? -- Alter table drop constraint doesn't seem to work on a primary key constraint in 7.2beta2 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bug?? -- Alter table drop constraint doesn't seem to work on a primary key constraint in 7.2beta2
Date
Msg-id 29191.1005351414@sss.pgh.pa.us
Whole thread Raw
In response to Bug?? -- Alter table drop constraint doesn't seem to work on a primary key constraint in 7.2beta2  (Barry Lind <barry@xythos.com>)
List pgsql-hackers
Barry Lind <barry@xythos.com> writes:
> files31=# alter table XYF_FILES DROP CONSTRAINT XYF_FILES_PK;
> ERROR:  parser: parse error at or near ";"

You forgot the RESTRICT/CASCADE option.

> I am assuming that this syntax should work because it is documented in 
> the 7.2 docs.

If it's documented without the option then the docs are in error;
where are you looking?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Doug McNaught
Date:
Subject: Re: best method of reloading pg_hba.conf
Next
From: Fernando Nasser
Date:
Subject: Re: best method of reloading pg_hba.conf