Re: CommandStatus from insert returning when using a portal.

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: CommandStatus from insert returning when using a portal.
Дата
Msg-id CADK3HHJKCpS-Fx-37ObLgM6VKdN-rwhbjNvgPobwiN7=AU8mqg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CommandStatus from insert returning when using a portal.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: CommandStatus from insert returning when using a portal.  (chap@anastigmatix.net)
Список pgsql-hackers
Дерево обсуждения
See attached pcap file

after the execute of the portal it returns INSERT 0 0
Dave Cramer


On Fri, 14 Jul 2023 at 12:57, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Fri, Jul 14, 2023 at 9:50 AM David G. Johnston <david.g.johnston@gmail.com> wrote:

Fixing that test in some manner and recompiling psql seems like it should be the easiest way to produce a core-only test case.


Apparently not - since it (ExecQueryUsingCursor) literally wraps the query in a DECLARE CURSOR SQL Command which prohibits INSERT...

I suppose we'd have to write a psql equivalent of ExecQueryUsingPortal that iterates over via fetch to make this work...probably more than I'm willing to try.

David J.
Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: CommandStatus from insert returning when using a portal.
Следующее
От: chap@anastigmatix.net
Дата:
Сообщение: Re: CommandStatus from insert returning when using a portal.