Re: CommandStatus from insert returning when using a portal.
| От | David G. Johnston |
|---|---|
| Тема | Re: CommandStatus from insert returning when using a portal. |
| Дата | |
| Msg-id | CAKFQuwY8L5oRRRjcMSDfbBtP58QKw0EjMN+_UDogXcgAkur8yA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: CommandStatus from insert returning when using a portal. (Dave Cramer <davecramer@gmail.com>) |
| Список | pgsql-hackers |
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 usedLooking 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
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 по дате отправления: