Re: CommandStatus from insert returning when using a portal.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: CommandStatus from insert returning when using a portal.
Дата
Msg-id CAKFQuwYBALhvo4anw3sqk_AHRO+9XR1vL5g_BWsPGK8CVcCy5w@mail.gmail.com
обсуждение исходный текст
Ответ на CommandStatus from insert returning when using a portal.  (Dave Cramer <davecramer@gmail.com>)
Ответы Re: CommandStatus from insert returning when using a portal.  (Dave Cramer <davecramer@gmail.com>)
Список pgsql-hackers
Дерево обсуждения
On Wed, Jul 12, 2023 at 1:03 PM Dave Cramer <davecramer@gmail.com> wrote:

INSERT INTO test_table (cnt) VALUES (1), (2) RETURNING id

if a portal is used to get the results then the CommandStatus

IIUC the portal is not optional if you including the RETURNING clause.

There is no CommandStatus message in the protocol, the desired information is part of the command tag returned in the CommandComplete message.  You get that at the end of the command, which has been defined as when any portal produced by the command has been fully executed.

You probably should add your desire to the Version 4 protocol ToDo on the wiki.

https://wiki.postgresql.org/wiki/Todo#Wire_Protocol_Changes_.2F_v4_Protocol

If that ever becomes an active project working through the details of that list for desirability and feasibility would be the first thing to happen.

David J.

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

Предыдущее
От: Dave Cramer
Дата:
Сообщение: CommandStatus from insert returning when using a portal.
Следующее
От: Gurjeet Singh
Дата:
Сообщение: Re: CommandStatus from insert returning when using a portal.