Re: Global temporary tables

On Tue, 14 Jul 2026 at 14:38, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> 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.