Re: Remove Modifiers on Table

On 05/17/2011 11:29 AM, Carlos Mennens wrote:
> On Tue, May 17, 2011 at 2:21 PM, Raymond O'Donnell<rod(at)iol(dot)ie> wrote:
>> That's because of what I just mentioned above. :-) It's not a type: it's
>> just a shortcut. What you need to do instead is something like this:
>>
>> -- Create the sequence.
>> create sequence users_id_seq;
>>
>> -- Tell the column to pull default values from the sequence.
>> alter table users alter column id set default nextval('users_id_seq');
>>
>> -- Establish a dependency between the column and the sequence.
>> alter sequence users_id_seq owned by users.id;
>
> Yup - that explains that the shortcut doesn't work for existing tables
> but only during CREATE TABLE. Otherwise I will need to manually CREATE
> SEQUENCE...blah blah blah.

It will work for an existing table if you are adding a column with
'type' SERIAL. You just cannot change an existing column to 'type' SERIAL.

>
> Thank you!
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com