Bug #551: alter table add field serial - does not create serial field - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #551: alter table add field serial - does not create serial field
Date
Msg-id 200201041158.g04BwSm50383@postgresql.org
Whole thread Raw
Responses Re: Bug #551: alter table add field serial - does not create  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
wolfgang fuertbauer (w.fuertbauer@eunet.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

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Bug #549: select table privilege in postgres allows
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #552: src/backend/catalog/README