\set r random(1, 5) \if :r = 1 CREATE TABLE t_:client_id (id int, a text); ALTER TABLE t_:client_id ADD COLUMN b int; BEGIN; INSERT INTO t_:client_id VALUES (1, 'x', 2); \sleep 2 ms COMMIT; DROP TABLE t_:client_id; \elif :r = 2 BEGIN; SELECT pg_current_xact_id(); \sleep 1 ms SAVEPOINT s; CREATE TABLE t_:client_id (id int, a text, b int); RELEASE s; \sleep 1 ms COMMIT; BEGIN; INSERT INTO t_:client_id VALUES (1, 'x', 2); \sleep 2 ms COMMIT; DROP TABLE t_:client_id; \elif :r = 3 BEGIN; CREATE TABLE t_:client_id (id int, a text, b int); \sleep 1 ms PREPARE TRANSACTION 'g:client_id'; COMMIT PREPARED 'g:client_id'; BEGIN; INSERT INTO t_:client_id VALUES (1, 'x', 2); \sleep 2 ms COMMIT; DROP TABLE t_:client_id; \elif :r = 4 CREATE TABLE t_:client_id (id int, a text); BEGIN; SAVEPOINT s; ALTER TABLE t_:client_id ADD COLUMN z int; \sleep 1 ms ROLLBACK TO s; ALTER TABLE t_:client_id ADD COLUMN b int; \sleep 1 ms COMMIT; BEGIN; INSERT INTO t_:client_id VALUES (1, 'x', 2); \sleep 1 ms INSERT INTO t_:client_id VALUES (2, 'y', 3); COMMIT; DROP TABLE t_:client_id; \else CREATE TABLE t_:client_id (id int, a text, b int); INSERT INTO t_:client_id VALUES (0, 'x', 2); ALTER TABLE t_:client_id ALTER COLUMN id TYPE bigint; BEGIN; UPDATE t_:client_id SET b = 3; INSERT INTO t_:client_id VALUES (1, 'x', 2); \sleep 2 ms COMMIT; BEGIN; CREATE TABLE v_:client_id (id int); \sleep 1 ms ROLLBACK; DROP TABLE t_:client_id; \endif