| 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: | Whole Thread | Raw Message | 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 |