CREATE TABLE test_seq (
id integer PRIMARY KEY,
val varchar NOT NULL
);
INSERT INTO test_seq(val) VALUES ('some value'), ('other value');
SELECT * FROM test_seq;
BEGIN TRANSACTION;
INSERT INTO test_seq(val) VALUES ('value3'), ('value4'), ('value5');
SELECT * FROM test_seq;
ROLLBACK;
INSERT INTO test_seq(val) VALUES ('value6');
SELECT * FROM test_seq;