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