From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Dave Cramer <davecramer(at)gmail(dot)com> |
Cc: | "chap(at)anastigmatix(dot)net" <chap(at)anastigmatix(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: CommandStatus from insert returning when using a portal. |
Date: | 2023-07-14 15:53:29 |
Message-ID: | CAKFQuwY8L5oRRRjcMSDfbBtP58QKw0EjMN+_UDogXcgAkur8yA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, Jul 13, 2023 at 6:07 PM Dave Cramer <davecramer(at)gmail(dot)com> wrote:
> On Thu, 13 Jul 2023 at 10:24, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Thursday, July 13, 2023, Dave Cramer <davecramer(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-07-14 15:57:09 | Re: Allowing parallel-safe initplans |
Previous Message | Tomas Vondra | 2023-07-14 15:51:45 | Re: PATCH: Using BRIN indexes for sorted output |