subject:"\[SQL\] drop constraint primary key"

Re: [SQL] drop constraint primary key

2002-10-03 Thread Tom Lane

"Marie G. Tuite" <[EMAIL PROTECTED]> writes: > Running above, am trying to drop the primary key, but get the follwing > error. > project=# alter table class_teacher_rlt drop constraint > class_teacher_rlt_pkey restrict; > ERROR: ALTER TABLE / DROP CONSTRAINT: class_teacher_rlt_pkey does not exist

[SQL] drop constraint primary key

2002-10-03 Thread Marie G. Tuite

project=# select version(); version - PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row) Running above, am trying to drop the primary key, but get the follwing error. project=# alter table cl