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

From: Barry Lind <barry(at)xythos(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Bug?? -- Alter table drop constraint doesn't seem to work on a primary key constraint in 7.2beta2
Date: 2001-11-09 23:10:27
Message-ID: 3BEC6263.4080806@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I am trying to use the new 'alter table drop constraint' syntax to drop
a primary key constraint (or foreign key constraint) on the 7.2beta2
code. It gives me the following error:

files31=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2b2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

files31=# alter table XYF_FILES DROP CONSTRAINT XYF_FILES_PK;
ERROR: parser: parse error at or near ";"

When I look at the definition on the table through psql \d I can see
that this constraint does indeed exist. What am I doing wrong?

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

thanks,
--Barry

PS I also notice that 'alter table drop constraint' doesn't appear to be
tested at all in the alter_table regression test. 'alter table add
constraint' is tested however.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-11-09 23:31:47 Re: best method of reloading pg_hba.conf
Previous Message Bruce Momjian 2001-11-09 22:44:26 Re: best method of reloading pg_hba.conf