adding columns with defaults is not implemented

From: "Marcelo" <marcelo(at)humano2(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: adding columns with defaults is not implemented
Date: 2005-06-02 20:29:04
Message-ID: 014601c567b1$b81a2280$500aa8c0@humano2.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2005-06-02 20:43:20 Re: adding columns with defaults is not implemented
Previous Message Sean Davis 2005-06-02 20:04:10 Re: Limits of SQL