Re: NOTIFY in multi-statement PQexec() not sent outside of transaction

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: NOTIFY in multi-statement PQexec() not sent outside of transaction
Дата
Msg-id CAKFQuwbWjDJ78bAE-XrF4Avig5kNddmbttBVb51RXHivPz-qdQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: NOTIFY in multi-statement PQexec() not sent outside of transaction  (John Muehlhausen <jgm@jgm.org>)
Ответы Re: NOTIFY in multi-statement PQexec() not sent outside of transaction  (John Muehlhausen <jgm@jgm.org>)
Список pgsql-bugs
On Mon, Apr 20, 2020 at 1:27 PM John Muehlhausen <jgm@jgm.org> wrote:


> My perspective as a libpq user is that multi-statement PQexec() should have
> the same effects as multiple PQexec() calls other than for the former
> dropping the results of all but the most recent statement.
 
Still, even without considering my usage, I find it odd that this would not be considered a bug, for the reason in my first sentence above.  The current behavior means that the user has to think about transactions "and something else" when reasoning about the effects of statements.  I would vote to remove the "and something else" which would then remove the need to augment the current documentation.  As it stands, at minimum, the documentation needs to warn the user that similar notify effects are unachievable in the multi-statement realm?

The deeper into the architecture the change the more resistant to change it should be.  This is pretty low-level and the benefits don't seem that great.  It is functional, and the usage pattern involved, multi-statement commands, is one that is actively discouraged - so from my perspective classifying this as a bug that the core team should fix is unappealing.  If someone wants to offer up a feature enhancement patch for critique then we'll see.

David J.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: NOTIFY in multi-statement PQexec() not sent outside of transaction
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16382: pgdg-redhat-repo-42.0-9 has two sections with the same name - causing issues