Re: Procedure support improvements
Dave Cramer <[email protected]> Wed, 24 Jul 2019 07:09:02 -0400
| Newsgroups | gmane.comp.db.postgresql.jdbc |
|---|---|
| Message-ID | <CADK3HH+P2tetetb4megAgF=XE+oRbMX0HKPodZQ2smtP_WspqA@mail.gmail.com> |
On Tue, 23 Jul 2019 at 22:00, David Rader <[email protected]> wrote: > > > On Tue, Jul 23, 2019 at 4:37 PM Dave Cramer <[email protected]> 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. " > https://www.postgresql.org/docs/11/plpgsql-transactions.html > > > 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