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  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Re: Cannot add an column of type serial or bigserial  (Andreas Pflug <pgadmin@pse-consulting.de>)
Список 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 по дате отправления:

Предыдущее
От: Miernik
Дата:
Сообщение: mouse-free PgadminIII usage
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Cannot add an column of type serial or bigserial