On Tue, 14 Jul 2026 at 14:38, Zsolt Parragi <[email protected]> wrote: > Hello! > > 2. And I also have some other questions above global temp sequences: > > CREATE GLOBAL TEMP SEQUENCE s; > CREATE GLOBAL TEMP TABLE t (a int, b serial); > > BEGIN; > SELECT nextval('s'); -- 1 > SELECT nextval('s'); -- 2 > SELECT nextval('s'); -- 3 > ROLLBACK; > SELECT nextval('s'); -- 1 again, is this intended? > > also within a single transaction with savepoints: > > BEGIN; > SAVEPOINT sp; > INSERT INTO t(a) VALUES (1); -- b = 1 > ROLLBACK TO sp; > INSERT INTO t(a) VALUES (2); -- b = 1 again > COMMIT; > SELECT a, b FROM t; -- 2,1 ? >
Per [1], this does not seem to be the expected outcome. [1] https://www.postgresql.org/message-id/CAEZATCXYqx_aiDHWn9qUB8QGjE%3DdMzUEt_9WKjyHvDQFFf0U4w%40mail.gmail.com -- Regards, Japin Li ChengDu WenWu Information Technology Co., Ltd.
