Postgres Pro
Downloads
Home   >   mailing lists

Re: CommandStatus from insert returning when using a portal. - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: CommandStatus from insert returning when using a portal.
Date
Msg-id CAKFQuwYBALhvo4anw3sqk_AHRO+9XR1vL5g_BWsPGK8CVcCy5w@mail.gmail.com
Whole thread Raw
In response to CommandStatus from insert returning when using a portal.  (Dave Cramer <davecramer@gmail.com>)
Responses Re: CommandStatus from insert returning when using a portal.
List pgsql-hackers
Tree view
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 by date:

Previous
From: Dave Cramer
Date:
Subject: CommandStatus from insert returning when using a portal.
Next
From: Gurjeet Singh
Date:
Subject: Re: CommandStatus from insert returning when using a portal.