cockroachdb / cockroachdb/cockroach
sql,plpgsql: implement AND CHAIN syntax for COMMIT and ROLLBACK
Open
A-sql-executor
A-sql-pgcompat
A-sql-plpgsql
A-sql-routine
C-enhancement
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
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.
Note: ROLLBACK AND CHAIN also is a regular SQL statement in Postgres, not just PL/pgSQL.
Jira issue: CRDB-36216
Contributor guide
Assessment
This issue has not been assessed yet.