On 05/17/2011 11:29 AM, Carlos Mennens wrote:
On Tue, May 17, 2011 at 2:21 PM, Raymond O'Donnell<rod@xxxxxx> 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.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
