Postgres Pro
Downloads
Home   >   mailing lists

Re: Procedure support improvements - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Procedure support improvements
Date
Msg-id CADK3HH+P2tetetb4megAgF=XE+oRbMX0HKPodZQ2smtP_WspqA@mail.gmail.com
Whole thread Raw
In response to Re: Procedure support improvements  (David Rader <david.rader@gmail.com>)
List pgsql-jdbc
Tree view


On Tue, 23 Jul 2019 at 22:00, David Rader <david.rader@gmail.com> wrote:


On Tue, Jul 23, 2019 at 4:37 PM Dave Cramer <pg@fastcrypt.com> wrote:
Hmmm who knew you couldn't call a procedure inside a transaction. That just seems broken


Yeah, the description in the docs is:
"Transaction control is only possible in CALL or DO invocations from the top level or nested CALL or DO invocations without any other intervening command. "


Which means to be able to call procedures that use commit or rollback you have to be able to call them without a begin...

This makes calling procedures a mostly useless feature IMO. What's the motivation to make this work?

Dave

pgsql-jdbc by date:

Previous
From: David Rader
Date:
Subject: Re: Procedure support improvements
Next
From: Matteo Melli
Date:
Subject: [pgjdbc/pgjdbc] fcbbc3: Updated scram to version 2.0 (#1532)