Re: BUG #16867: savepoints vs. commit and chain

Поиск
Список
Период
Сортировка
От Arthur Nascimento
Тема Re: BUG #16867: savepoints vs. commit and chain
Дата
Msg-id CALVFHFaBUXnCxv2kfG67=3NR=WPkVGgE_5Cf9S-LDPNYAwUORQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: BUG #16867: savepoints vs. commit and chain  (Fujii Masao <masao.fujii@oss.nttdata.com>)
Список pgsql-bugs
On Mon, 15 Feb 2021 at 17:54, PG Bug reporting form
<noreply@postgresql.org> wrote:
> On a trivial transaction, I might do:
>
> =# begin;
> *=# commit and chain;
> *=# -- In this point I'm inside a second transaction

I forgot to mention that this case also works as expected:

=# begin;
*=# savepoint foo;
*=# release foo;
*=# commit and chain;
*=# -- In this point I'm also inside a second transaction

So it's only the unmatched savepoint/release transactions that are an issue.

I also attached the change I did to psql locally. But since it didn't
solve the issue, it's mostly for curiosity's sake.

Thanks,
Tureba - Arthur Nascimento

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16867: savepoints vs. commit and chain
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #16865: Regression: GIN Negated prefix search returns results that contain the search term