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.
