multiple transactions in one session in postgresql?

Question

Is it possible to run/create multiple transactions in one session in postgresql?

BEGIN transaction; --tran1
update  table set b=1; 


BEGIN transaction;  --tran2
update  table set b=2;

COMMIT transaction;
COMMIT transaction;

Frank Heikens · Accepted Answer · 2021-05-27 19:43:59Z

1

Yes, that's called a SAVEPOINT:

BEGIN;
    update  table set b=1; 
    SAVEPOINT my_savepoint;
    update  table set b=2;
    RELEASE SAVEPOINT my_savepoint;
COMMIT;

answered May 27, 2021 at 19:43

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Perhaps it should be noted that rolling back the main transaction will automatically roll back the subtransaction.

Unlike tsql, "begin" and "begin transaction" are same statement for postgresql? Is it correct?

@ArcilTralleis: Please check the manual: postgresql.org/docs/current/sql-begin.html The answer is Yes