Re: Procedure support improvements

On Tue, 23 Jul 2019 at 22:00, David Rader <david(dot)rader(at)gmail(dot)com> wrote:

>
>
> On Tue, Jul 23, 2019 at 4:37 PM Dave Cramer <pg(at)fastcrypt(dot)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. "
> 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