Re: Procedure support improvements

Dave Cramer <[email protected]> Mon, 26 Aug 2019 14:31:44 -0400

Newsgroups	gmane.comp.db.postgresql.jdbc,gmane.comp.db.postgresql.devel.general
Message-ID	<CADK3HHLbnfG5TTuMyTt3CrS7nYvXxLhdwNBJt3sEp-053pbc=g@mail.gmail.com>

On Mon, 26 Aug 2019 at 14:14, Tom Lane <[email protected]> wrote:

> Laurenz Albe <[email protected]> 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

[email protected]
www.postgresintl.com


>
>