On Thu, Jul 13, 2023 at 6:07 PM Dave Cramer <davecra...@gmail.com> wrote:
> On Thu, 13 Jul 2023 at 10:24, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Thursday, July 13, 2023, Dave Cramer <davecra...@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.