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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Barry Lind <barry(at)xythos(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Bug?? -- Alter table drop constraint doesn't seem to work on a primary key constraint in 7.2beta2
Date: 2001-11-10 00:16:54
Message-ID: 29191.1005351414@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Barry Lind <barry(at)xythos(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fernando Nasser 2001-11-10 00:21:02 Re: best method of reloading pg_hba.conf
Previous Message Knut Forkalsrud 2001-11-09 23:55:58 Re: 'real' strange problem in 7.1.3