> From: Tom Lane [mailto:t...@sss.pgh.pa.us] > >> The file xact.c contains references to sub-transactions (subxact) and > >> transaction nesting level, but no obvious documentation about what > >> these correspond to in SQL. > > > Subtransactions are used to implement SAVEPOINT, and also BEGIN blocks > > with EXCEPTION clauses in plpgsql. > > Yeah. The implementation is based on nested subtransactions, and that > concept also applies pretty directly to, eg, BEGIN/EXCEPT blocks in plpgsql. > But what's exposed to SQL is SAVEPOINT/RELEASE SAVEPOINT/ ROLLBACK TO > SAVEPOINT, because those operations are what the standard specifies. If you > hold your head at the correct angle you can see those as nested > subtransactions, but it's not exactly obvious --- mainly because RELEASE and > ROLLBACK can exit multiple levels of nested subtransaction in one command.
Yes, that answers the question. What now concerns me is that access to these capability seems to require calling these three 'internal' functions, for which it's hard to determine the prerequisites. The SPI interface is well-documented and the conversion functions I'm using are not stateful and look pretty safe. I've got the process model figured out well enough, but the transaction model is not so easy. State looks important; so does memory management. Are there specific requirements or things to do/avoid in order to use subtransactions (at the PL API level)? Regards David M Bennett FACS Andl - A New Database Language - andl.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers