From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk> |
Cc: | 'Tim Pushor' <timp(at)crossthread(dot)com>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: SERIAL does not ROLLBACK |
Date: | 2003-03-12 16:55:04 |
Message-ID: | 20030312165504.GA26509@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Wed, Mar 12, 2003 at 15:43:52 -0000,
"Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Aarni Ruuhimäki | 2003-03-12 17:22:04 | Re: Last access time for a table |
Previous Message | Renê Salomão | 2003-03-12 16:31:36 | Re: [NOVICE] create function pl/pgsql c langauge |