plpgsql: implement AND CHAIN syntax for COMMIT and ROLLBACK

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

https://www.cockroachlabs.com

Other

29.96k stars 3.79k forks source link

plpgsql: implement AND CHAIN syntax for COMMIT and ROLLBACK #119646

Open DrewKimball opened 7 months ago

DrewKimball commented 7 months ago

PL/pgSQL COMMIT and ROLLBACK statements start the new transaction using the session defaults. Postgres has COMMIT AND CHAIN and ROLLBACK AND CHAIN, which cause the new transaction to have the same settings as the previous one. This issue tracks adding support for this syntax.

Jira issue: CRDB-36216

zyf123123 commented 7 months ago

I am going to try this one 😺