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

Re: Creating a new column with SERIAL as data type

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Creating a new column with SERIAL as data type
Date: 2004-09-20 04:18:59
Message-ID: 20040920041859.60891.qmail@web61207.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thank you very much Mr. Lane.
It worked. 
Would you mind explaining the code that you sent. 
I would appreciate and curious to learn in fact the
meaning of the pg/pl sql statements. 
thank you. 
Kumar.


--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Kumar S <ps_postgres(at)yahoo(dot)com> writes:
> > friends=> alter table friend  add column fr_id
> serial;
> > NOTICE:  ALTER TABLE will create implicit sequence
> "friend_fr_id_seq" for "serial" column
> "friend.fr_id"
> > ERROR:  adding columns with defaults is not
> implemented
> > HINT:  Add the column, then use ALTER TABLE SET
> DEFAULT.
> 
> > Can any one suggest what is wrong here. 
> 
> Just what it says: adding columns with defaults is
> not implemented.
> (It is implemented in 8.0, but that won't help you
> today.)  You can
> do it by hand:
> 
> create sequence friend_fr_id_seq;
> alter table friend add column fr_id int;
> update friend set fr_id =
> nextval('friend_fr_id_seq');
> alter table friend alter column fr_id set default
> nextval('friend_fr_id_seq');
> 
> This isn't an exact substitute since the sequence
> will appear as
> a standalone object and not be hidden behind the
> "serial" column,
> but it's functionally equivalent.
> 
> 			regards, tom lane
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map
> settings
> 



		
__________________________________
Do you Yahoo!?
Yahoo! Mail is new and improved - Check it out!
http://promotions.yahoo.com/new_mail

In response to

pgsql-novice by date

Next:From: Martin AtukundaDate: 2004-09-20 09:24:02
Subject: ECPG threads
Previous:From: Tom LaneDate: 2004-09-20 03:32:21
Subject: Re: Creating a new column with SERIAL as data type

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