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 CAKFQuwb720wS1jnsVywSXO03+M-qOwvnhdNY5=wYtcFNb31wiQ@mail.gmail.com
Whole thread Raw
In response to Re: CommandStatus from insert returning when using a portal.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: CommandStatus from insert returning when using a portal.
List pgsql-hackers
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 by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: CommandStatus from insert returning when using a portal.
Next
From: Dave Cramer
Date:
Subject: Re: CommandStatus from insert returning when using a portal.