Re: Procedure support improvements

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Procedure support improvements
Дата
Msg-id CADK3HH+P2tetetb4megAgF=XE+oRbMX0HKPodZQ2smtP_WspqA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Procedure support improvements  (David Rader <david.rader@gmail.com>)
Список pgsql-jdbc
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: David Rader
Дата:
Сообщение: Re: Procedure support improvements
Следующее
От: Matteo Melli
Дата:
Сообщение: [pgjdbc/pgjdbc] fcbbc3: Updated scram to version 2.0 (#1532)