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

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

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: w(dot)fuertbauer(at)eunet(dot)at, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug #551: alter table add field serial - does not create
Date: 2002-01-04 18:21:08
Message-ID: 200201041821.g04IL9f07152@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Yes, this is a known bug:

From TODO list:

        o ALTER TABLE ADD COLUMN column SERIAL doesn't create sequence


---------------------------------------------------------------------------

pgsql-bugs(at)postgresql(dot)org wrote:
> 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
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-01-04 18:26:33
Subject: Re: Bug #552: src/backend/catalog/README
Previous:From: Lee KindnessDate: 2002-01-04 16:02:14
Subject: ECPG bug in --help

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