Re: altering a table to set serial function - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: altering a table to set serial function
Date
Msg-id 20040728131331.GD20734@svana.org
Whole thread Raw
In response to Re: altering a table to set serial function  (Prabu Subroto <prabu_subroto@yahoo.com>)
List pgsql-general
On Wed, Jul 28, 2004 at 05:09:33AM -0700, Prabu Subroto wrote:
> Dear Scott...
>
> My God.... so I can not use "alter table" to define a
> column with int data type?

eh? Sure you can:

alter table x add column y integer;

What's he's saying is that the "serial" shortcut isn't there and
proceeded to tell you how to do it manually...
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: Geoff Caplan
Date:
Subject: Re: Sql injection attacks
Next
From: Doug McNaught
Date:
Subject: Re: altering a table to set serial function