Re: CommandStatus from insert returning when using a portal.

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: CommandStatus from insert returning when using a portal.
Дата
Msg-id CADK3HHK7wS=wLxN8oyVdxK=-pYR=A0r2yFSNuG_BvK+2KtTcpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CommandStatus from insert returning when using a portal.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
Дерево обсуждения

Dave Cramer


On Wed, 12 Jul 2023 at 16:31, David G. Johnston <david.g.johnston@gmail.com> wrote:
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.
From my testing it isn't required.  

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.

I could argue that the insert is fully completed whether I read the data or not. 

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


thx, will do.

Dave

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

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