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

From Dave Cramer
Subject Re: CommandStatus from insert returning when using a portal.
Date
Msg-id CADK3HHK7wS=wLxN8oyVdxK=-pYR=A0r2yFSNuG_BvK+2KtTcpA@mail.gmail.com
Whole thread Raw
In response to Re: CommandStatus from insert returning when using a portal.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List 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 by date:

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