Chapter 43.8. "Transaction Management" fails to state two critical restrictions
PG Doc comments form <[email protected]> Mon, 30 Sep 2019 04:11:47 +0000
| Newsgroups | gmane.comp.db.postgresql.devel.documentation |
|---|---|
| Message-ID | <[email protected]> |
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html Description: This chapter fails to state: (1) If a PL/pgSQL procedure issues "commit" then it must be called with AUTOCOMMIT set to On. This is counter-intuitive. You'd expect the opposite. (2) If a PL/pgSQL procedure has a block statement with an exception section (this might be the procedure's defining block, or an inner block) then that block's executabe section must not issue "commit". Doing so causes a run-time error.