Re: Procedure support improvements

On Mon, 26 Aug 2019 at 14:14, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> writes:
> > Dave Cramer wrote:
> > test=> BEGIN;
> > BEGIN
> > test=> CALL testproc();
> > ERROR: invalid transaction termination
> > CONTEXT: PL/pgSQL function testproc() line 1 at COMMIT
>
> > What is the rationale for this?
>
> A procedure shouldn't be able to force commit of the surrounding
> transaction.
>
> As Dave noted, what would be nicer is for procedures to be able
> to start and commit autonomous transactions, without affecting
> the state of the outer transaction. We haven't got that though,
> and it looks like a lot of work to get there.
>

I'm less than motivated to hack the driver to make something work here
until we finish the server feature.

Who knows what that might bring ?

Dave Cramer

davec(at)postgresintl(dot)com
www.postgresintl.com

>
>