> I have just created a table using SELECT INTO however the PK was > supposed to be a serial. It is now an integer. To make it a serial I > just create the seq and set the default to be the nextval() of that > sequence right? is there anything else I need to do?
You'll want to do this: ALTER SEQUENCE table_col_id_seq OWNED BY table.col_id; http://www.postgresql.org/docs/8.3/interactive/sql-altersequence.html > It'll maintain the > transactional safety of a serial created default, right? I.e., it'll > not rollback seq values on a transaction abortion will it? Yes -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
