Altering table error
От | Josep Sànchez i Mesegué |
---|---|
Тема | Altering table error |
Дата | |
Msg-id | 3EC8A750.10604@transpujol.com обсуждение исходный текст |
Ответы |
Re: Altering table error
|
Список | pgsql-novice |
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I'm trying to alter an existing table, whith data in it, adding a column called "cap_id" that should be a "serial" or "serial8" type, but when I try to do it I receive the next message: | provesmasis-# provesmasis=# alter table captrajectes add column cap_id serial; | NOTICE: ALTER TABLE will create implicit sequence 'captrajectes_cap_id_seq' for SERIAL column 'captrajectes.cap_id' | NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index 'captrajectes_cap_id_key' for table 'captrajectes' | ERROR: parser: parse error at or near "notice" | provesmasis=# NOTICE: ALTER TABLE will create implicit sequence 'captrajectes_cap_id_seq' for SERIAL column 'captrajectes.cap_id' | provesmasis-# NOTICE: ALTER TABLE / ADD UNIQUE will create implicit index 'captrajectes_cap_id_key' for table 'captrajectes' | provesmasis-# ERROR: Adding columns with defaults is not implemented. | provesmasis-# Add the column, then use ALTER TABLE SET DEFAULT. What am I doing wrong? Thanks in advance for your answer. Josep Sànchez ~ [papapep] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+yKdP2vx52x0kyz4RAur2AJ9eIeWADsUJcB2E7jTgNA0fr/qQBACfevpE zdKjuFf2YB4K+x1S7LdYC2c= =HAAd -----END PGP SIGNATURE-----
В списке pgsql-novice по дате отправления: