sequences vs. transactions

From: Vazsonyi Peter <neko(at)sp1(dot)szif(dot)hu>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: sequences vs. transactions
Date: 1999-05-11 21:00:20
Message-ID: Pine.LNX.4.04.9905112045220.4043-100000@sp1.szif.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi!
I found a bug, with $SUBJ - i mean ... so look at this:
t=> begin;
BEGIN
t=> select nextval('some_seq');
nextval
-------
4
(1 row)
t=> rollback;
ROLLBACK
t=> select nextval('some_seq');
nextval
-------
5 <<<< five! and NOT 4 again, but 4 expected i think
(1 row)

Or seqences are special case in transations?

--
Neko the Servant of Crash
neko@(kornel.szif.hu|kva.hu) http://lsc.kva.hu

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brook Milligan 1999-05-11 21:59:34 Re: [HACKERS] Re: [SQL] plpgsql error
Previous Message gjerde 1999-05-11 20:11:40 Re: [HACKERS] 6.5 TODO list