Re: adding columns with defaults is not implemented

Marcelo wrote:
> Hi,
> Thanks for your reply, but I have some doubts.
>
> Are yoy sugesting I create the column as an Integer then change it to
> Serial? in Pgsql 7 you cant change a column type.

Serial is not a real data type. Do this.

create table foo (bar integer not null);
create sequence foo_bar_seq;
alter table foo alter column bar set default nextval('foo_bar_seq');

Sincerely,

Joshua D. Drake

>
> If I create the column as an int then add a default value, how can I make
> this default value increment with each insert?
>
> Thanks again for your help.
> Marcelo
>
>
> ----- Original Message -----
> From: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>
> To: "Marcelo" <marcelo(at)humano2(dot)com>
> Cc: <pgsql-general(at)postgresql(dot)org>
> Sent: Thursday, June 02, 2005 4:43 PM
> Subject: Re: [GENERAL] adding columns with defaults is not implemented
>
>
>
>>On Thu, 2005-06-02 at 15:29, Marcelo wrote:
>>
>>>Hello,
>>>Using Postgres 7.4, I am trying to perform an "alter table
>>>temptable add column "myCol" serial"
>>>
>>>It gives the following msg
>>>ERROR: adding columns with defaults is not implemented
>>>
>>>You cannot add a column that is serial in a table which already has
>>>data in postgres 7.
>>>
>>>Is there a way I can create a serial column on a table which already
>>>has data? Or is the only solution upgrading to postgres 8 ?
>>
>>You can add a default after you add the column with a separate alter
>>table statement...
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 2: you can get off all lists at once with the unregister command
>> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>
> ---------------------------(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

--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/