Skip site navigation (1) Skip section navigation (2)

Re: Cannot add an column of type serial or bigserial

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: David Sigeti <sigeti(at)lanl(dot)gov>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Cannot add an column of type serial or bigserial
Date: 2003-12-10 11:21:15
Message-ID: 3FD701AB.7060901@pse-consulting.de (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-hackers
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).
>
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.

Regards,
Andreas



In response to

Responses

pgsql-hackers by date

Next:From: strkDate: 2003-12-10 11:36:02
Subject: Re: ERROR: Index pg_toast_8443892_index is not a btree
Previous:From: Teodor SigaevDate: 2003-12-10 10:06:11
Subject: Re: Searching for substring with tsearch(1/2)

pgadmin-support by date

Next:From: Andreas PflugDate: 2003-12-10 11:24:26
Subject: Re: mouse-free PgadminIII usage
Previous:From: Ian FreislichDate: 2003-12-10 07:58:56
Subject: Re: Cannot add an column of type serial or bigserial

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group