Syntax error in DROP CONSTRAINT
От | Rajan Bhide |
---|---|
Тема | Syntax error in DROP CONSTRAINT |
Дата | |
Msg-id | FF851C7EEB75954F9BCFB5CA117AB1EC013FE2E5@delta.nulinkinc.com обсуждение исходный текст |
Ответы |
Re: Syntax error in DROP CONSTRAINT
|
Список | 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.
В списке pgsql-novice по дате отправления: