Altering table error

Поиск
Список
Период
Сортировка
Искать
От
Josep Sànchez i Mesegué
Тема
Altering table error
Дата
в 21:51:28
Msg-id
3EC8A750.10604@transpujol.com
Список
Дерево обсуждения
Altering table error Josep Sànchez i Mesegué <jsmesegue@transpujol.com>
Re: Altering table error Nabil Sayegh <postgresql@e-trolley.de>
Re: Altering table error papapep <papapep@gmx.net>
-----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 по дате отправления
От: Octavio Alvarez
Дата:
От: Louis Foucart
Дата:
FAQ