Creating a new column with SERIAL as data type

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Creating a new column with SERIAL as data type
Date: 2004-09-20 02:15:21
Message-ID: 20040920021521.22010.qmail@web61206.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi group,
I have an existing table with data loaded. Now I
wanted to create a column with SERIAL data type and
want to make that coulmn values as PRIMARY key.

I did the following:
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.

Thanks
Kumar


__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2004-09-20 03:32:21 Re: Creating a new column with SERIAL as data type
Previous Message Tom Lane 2004-09-19 03:03:28 Re: DST and time zones