May 2018
Intermediate to advanced
576 pages
30h 25m
English
The following commands cannot be included in a script that uses transactions in the way we just described:
None of these actions need to be run manually on a regular basis within complex programs, so this shouldn't be a problem for you.
Note also that these commands do not substantially alter the logical content of a database; that is, they don't create new user tables or alter any rows, so there's less need to use them inside complex transactions.
While PostgreSQL does not support nested transaction commands, it supports the notion of SAVEPOINT, which can be used to achieve the same behavior. ...