Re: Cannot add an column of type serial or bigserial

You cannot add a serial column after table creation time in PostgreSQL.

Chris

David Sigeti wrote:

> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>               http://archives.postgresql.org