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 > >
