[GENERAL] Serial Data Type

[Naz Gassiep]

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? 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?
Thanks,
- Naz.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general