Cannot add an column of type serial or bigserial

From: David Sigeti <sigeti(at)lanl(dot)gov>
To: pgadmin-support(at)postgresql(dot)org
Subject: Cannot add an column of type serial or bigserial
Date: 2003-12-10 05:55:16
Message-ID: 5.1.1.5.2.20031209225310.00b09070@x-mail.lanl.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-hackers

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(at)lanl(dot)gov
Surface mail: X-8, MS-F645, Los Alamos National Laboratory,
Los Alamos, NM 87545 USA

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-12-10 06:11:19 Re: Cannot add an column of type serial or bigserial
Previous Message Miernik 2003-12-10 01:59:30 mouse-free PgadminIII usage

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2003-12-10 05:56:38 Solaris Performance (Again)
Previous Message Christopher Kings-Lynne 2003-12-10 02:07:33 Re: ERROR: Index pg_toast_8443892_index is not a btree