Syntax error in DROP CONSTRAINT

From: "Rajan Bhide" <rbhide(at)starentnetworks(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Cc: "Ritesh Kumar Kakar" <rkakar(at)starentnetworks(dot)com>
Subject: Syntax error in DROP CONSTRAINT
Date: 2004-11-17 08:02:42
Message-ID: FF851C7EEB75954F9BCFB5CA117AB1EC013FE2E5@delta.nulinkinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi Forum,

I need to add a colume to existing composite primary key on a table.
I tried using following:
>> ALTER TABLE DROP CONSTRAINT tablename_pkey;
>> ALTER TABLE ADD CONSTRAINT PRIMARY KEY (col1, col2, col3, new_col4);

When I try this using Postgres 7.2.4 I get psql syntax error in DROP
CONSTRAINT.
ERROR: parser: parse error at or near ";"

E.g:
CREATE TABLE forwardinginfo
(
traptype smallint,
trapnumber smallint,
ipaddr varchar ( 16 ),
port integer DEFAULT 162,
snmpversion smallint,
PRIMARY KEY ( traptype, trapnumber, ipaddr, port )
);

ALTER TABLE forwardinginfo DROP CONSTRAINT forwardinginfo_pkey;
**** ERROR: parser: parse error at or near ";" ****

I want to add the new column after droping the existing constraint.
ALTER TABLE forwardinginfo ADD CONSTRAINT PRIMARY KEY ( traptype,
trapnumber, ipaddr, port, snmpversion);

If I try the same thing with the latest 7.5 version, I see NO error.
How do I perform this with my 7.2.4 postgresql version server?

Thanks,
Rajan.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Matt Arnilo S. Baluyos 2004-11-17 09:12:15 Previous month function
Previous Message sarlav kumar 2004-11-16 22:38:35 Index scan problem