sequences vs. transactions - Mailing list pgsql-hackers

From Vazsonyi Peter
Subject sequences vs. transactions
Date
Msg-id Pine.LNX.4.04.9905112045220.4043-100000@sp1.szif.hu
Whole thread Raw
In response to 6.5 TODO list  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: sequences vs. transactions
List 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



pgsql-hackers by date:

Previous
From: gjerde@icebox.org
Date:
Subject: Re: [HACKERS] 6.5 TODO list
Next
From: Brook Milligan
Date:
Subject: Re: [HACKERS] Re: [SQL] plpgsql error