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 CAKFQuwY8L5oRRRjcMSDfbBtP58QKw0EjMN+_UDogXcgAkur8yA@mail.gmail.com
Whole thread Raw
In response to Re: CommandStatus from insert returning when using a portal.  (Dave Cramer <davecramer@gmail.com>)
List pgsql-hackers
Tree view
On Thu, Jul 13, 2023 at 6:07 PM Dave Cramer <davecramer@gmail.com> wrote:
On Thu, 13 Jul 2023 at 10:24, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thursday, July 13, 2023, Dave Cramer <davecramer@gmail.com> wrote:

Any comment on why the CommandComplete is incorrect ?
It returns INSERT 0 0  if a cursor is used

 Looking at DECLARE it is surprising that what you describe is even possible.  Can you share a psql reproducer?

apologies, we are using a portal, not a cursor. 


Still the same basic request of providing a reproducer - ideally in psql.

IIUC a portal has to be used for a prepared (extended query mode) result set returning query.  v16 can now handle parameter binding so:

postgres=# \bind 4
postgres=# insert into ins values ($1) returning id;
 id
----
  4
(1 row)

INSERT 0 1

Which gives the expected non-zero command tag row count result.

David J.

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: PATCH: Using BRIN indexes for sorted output
Next
From: Tom Lane
Date:
Subject: Re: Allowing parallel-safe initplans