David Sigeti wrote:
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.serial isn't a true datatype but a keyword that can be used only at creation time. Still, pgAdmin3 should create the commands necessary for this to make life easier; I added this as a TODO item.
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).
Adding this functionality would be great but I suggest that the error message be changed right away as it is seriously misleading.
Thanks to everyone who took the time to help me out.
Yours, David
---
Dr. David E. Sigeti
Phone: 505-667-9239
E-mail: [EMAIL PROTECTED]
Surface mail: X-8, MS-F645, Los Alamos National Laboratory,
Los Alamos, NM 87545 USA
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
