Skip site navigation (1) Skip section navigation (2)

Re: transaction bug with sequences ?

From: xoror(at)infuse(dot)org
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: transaction bug with sequences ?
Date: 2002-03-14 11:51:12
Message-ID: Pine.GSO.4.10.10203141247400.1018-100000@aries (view raw or flat)
Thread:
Lists: pgsql-odbc
damn, the sequence in transactions is now also giving me problems in
pgsql. so this might be a pgsql bug (?) afterall ? or dit i miss something
here...

BEGIN TRANSACTION;
select nextval('some_id_seq');
ROLLBACK;

BEGIN TRANSACTION;       
select nextval('some_id_seq');       
ROLLBACK; 

BEGIN TRANSACTION;       
select nextval('some_id_seq');       
ROLLBACK; 

BEGIN TRANSACTION;       
select nextval('some_id_seq');       
ROLLBACK; 


the sequence value is incremented, but this shouldn't be the case because
i cancelled the transaction. 


In response to

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2002-03-14 15:46:13
Subject: Re: transaction bug with sequences ?
Previous:From: xororDate: 2002-03-14 11:42:47
Subject: transaction bug with sequences ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group