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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2003-12-10 11:24:26 | Re: mouse-free PgadminIII usage |
Previous Message | Ian Freislich | 2003-12-10 07:58:56 | Re: Cannot add an column of type serial or bigserial |
From | Date | Subject | |
---|---|---|---|
Next Message | strk | 2003-12-10 11:36:02 | Re: ERROR: Index pg_toast_8443892_index is not a btree |
Previous Message | Teodor Sigaev | 2003-12-10 10:06:11 | Re: Searching for substring with tsearch(1/2) |