Serial Data Type - Mailing list pgsql-general

From Naz Gassiep
Subject Serial Data Type
Date
Msg-id 47F44B25.3030201@mira.net
Whole thread Raw
Responses Re: Serial Data Type  ("Adam Rich" <adam.r@sbcglobal.net>)
Re: Serial Data Type  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: Ted Byers
Date:
Subject: Re: (FAQ?) JOIN condition - 'WHERE NULL = NULL'
Next
From: "Adam Rich"
Date:
Subject: Re: Serial Data Type