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 [EMAIL PROTECTED])

Reply via email to