wolfgang fuertbauer ([EMAIL PROTECTED]) 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly