Thread: BUG #4023: The transaction control does not work for sequences
BUG #4023: The transaction control does not work for sequences
From
"Giovani Murilo Dantas Correa"
Date:
The following bug has been logged online: Bug reference: 4023 Logged by: Giovani Murilo Dantas Correa Email address: contato@isolution.inf.br PostgreSQL version: 8.3.0 and 8.1.9 Operating system: Linux 2.6.X (Slackware and Fedora) Description: The transaction control does not work for sequences Details: create sequence seq_test; select nextval('seq_test'); --return value 1 select nextval('seq_test'); --return value 2 select nextval('seq_test'); --return value 3 BEGIN; select nextval('seq_test'); --return value 4 select nextval('seq_test'); --return value 5 select nextval('seq_test'); --return value 6 ROLLBACK; select currval('seq_test'); --return value 6 This is not right. The currval must have be 3 and not 6.
"Giovani Murilo Dantas Correa" <contato@isolution.inf.br> writes: > Description: The transaction control does not work for sequences This is not a bug. It is an intentional and very clearly documented behavior. regards, tom lane