Bug #551: alter table add field serial - does not create serial field

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #551: alter table add field serial - does not create serial field
Date: 2002-01-04 11:58:28
Message-ID: 200201041158.g04BwSm50383@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

wolfgang fuertbauer (w(dot)fuertbauer(at)eunet(dot)at) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
alter table add field serial - does not create serial field

Long Description
altering an existing table and adding a field from type serial via

>>alter table test add (s serial);<<

does not add a serial, but an integer field.

Sample Code
create table t (t text);
CREATE
\d t
Table "t"
Attribute | Type | Modifier
-----------+------+----------
t | text |

alter table t add s serial;
ALTER

\d t
Table "t"
Attribute | Type | Modifier
-----------+---------+----------
t | text |
s | integer |

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message andrea gelmini 2002-01-04 12:13:02 ehm...
Previous Message Jan Wieck 2002-01-03 19:09:32 Re: Refcursor problem