Re: [HACKERS] About subxact and xact nesting level...

2016-05-02 Thread dandl
> ow...@postgresql.org] On Behalf Of Tom Lane > > Are there specific requirements or things to do/avoid in order to use > > subtransactions (at the PL API level)? > > There isn't, currently, any very hard-and-fast rule about what APIs > extensions should use or not use. My advice is to borrow fre

Re: [HACKERS] About subxact and xact nesting level...

2016-05-02 Thread Tom Lane
"dandl" writes: > Are there specific requirements or things to do/avoid in order to use > subtransactions (at the PL API level)? There isn't, currently, any very hard-and-fast rule about what APIs extensions should use or not use. My advice is to borrow freely from existing PLs, particularly pl/

Re: [HACKERS] About subxact and xact nesting level...

2016-05-02 Thread dandl
> 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 blo

Re: [HACKERS] About subxact and xact nesting level...

2016-05-02 Thread david
> From: Thomas Munro [mailto:thomas.mu...@enterprisedb.com] > > 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. A search shows that plpython supports > > something called “p

Re: [HACKERS] About subxact and xact nesting level...

2016-05-02 Thread dandl
> From: Thomas Munro [mailto:thomas.mu...@enterprisedb.com] > > 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. A search shows that plpython supports > > something called “p

Re: [HACKERS] About subxact and xact nesting level...

2016-05-01 Thread Tom Lane
Thomas Munro writes: > On Mon, May 2, 2016 at 12:24 PM, wrote: >> 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 als

Re: [HACKERS] About subxact and xact nesting level...

2016-05-01 Thread Thomas Munro
On Mon, May 2, 2016 at 12:24 PM, wrote: > Still trying to find my way around the source code… > > > > 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. A search shows that plpyth