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