On Tue, May 17, 2011 at 2:21 PM, Raymond O'Donnell <[email protected]> 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. Thank you! -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
