Cannot add an column of type serial or bigserial
От | David Sigeti |
---|---|
Тема | Cannot add an column of type serial or bigserial |
Дата | |
Msg-id | 5.1.1.5.2.20031209225310.00b09070@x-mail.lanl.gov обсуждение исходный текст |
Ответы |
Re: Cannot add an column of type serial or bigserial
Re: Cannot add an column of type serial or bigserial |
Список | pgadmin-support |
Dear Pgadmin Folks, I am using pgadminIII 1.0.2 with PostgreSQL 7.4 under W2K SP4 and Cygwin (current as of 2 or 3 weeks ago). The server is running locally. If I attempt to add an column of type serial or bigserial to a table, the operation fails with a message telling me that adding an column with a default value is not implemented. What is really weird is that one can, in fact, add a column with a default value, like an int4 with a default value or 0. The problem does not arise if the serial (or bigserial) column is created when the table is created (as a part of CREATE TABLE). Yours, David --- Dr. David E. Sigeti Phone: 505-667-9239 E-mail: sigeti@lanl.gov Surface mail: X-8, MS-F645, Los Alamos National Laboratory, Los Alamos, NM 87545 USA
В списке pgadmin-support по дате отправления: