Re: SERIAL does not ROLLBACK - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: SERIAL does not ROLLBACK
Date
Msg-id 20030312165504.GA26509@wolff.to
Whole thread Raw
In response to Re: SERIAL does not ROLLBACK  ("Henshall, Stuart - Design & Print" <SHenshall@westcountry-design-print.co.uk>)
List pgsql-novice
On Wed, Mar 12, 2003 at 15:43:52 -0000,
  "Henshall, Stuart - Design & Print" <SHenshall@westcountry-design-print.co.uk> wrote:
> Off the top of my head the only way I can see to reliably do this is
> something like the following:

Another option is to keep the number in a separate (on row) table that would be
used only when doing inserts. That way you don't have conflicts with
selects or updates to the main table.

pgsql-novice by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: SERIAL does not ROLLBACK
Next
From: Aarni Ruuhimäki
Date:
Subject: Re: Last access time for a table