Re: autonomous transactions - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: autonomous transactions
Date
Msg-id 605e2970-428d-9b55-5ea9-6ce231edc02b@2ndquadrant.com
Whole thread Raw
In response to Re: autonomous transactions  (Serge Rielau <srielau@gmail.com>)
List pgsql-hackers
On 9/3/16 9:08 AM, Serge Rielau wrote:
> Interestingly, despite being supported in PL/SQL on nested BEGIN END blocks, 
> we nearly exclusively see AT’s covering the entire function or trigger.

Oracle only supports an entire PL/SQL function to be declared
autonomous.  But it was pretty easy in my implementation to allow that
for arbitrary blocks.  In fact, it would have been harder not to do that.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: autonomous transactions
Next
From: Ashutosh Bapat
Date:
Subject: Re: Declarative partitioning - another take