Re: CommandStatus from insert returning when using a portal. - Mailing list pgsql-hackers

From chap@anastigmatix.net
Subject Re: CommandStatus from insert returning when using a portal.
Date
Msg-id 0100cc45a5fb70ad689ff5dbafd9ef3a@anastigmatix.net
Whole thread Raw
In response to Re: CommandStatus from insert returning when using a portal.  (Dave Cramer <davecramer@gmail.com>)
Responses Re: CommandStatus from insert returning when using a portal.
List pgsql-hackers
On 2023-07-12 20:57, Dave Cramer wrote:
> Without a cursor it returns right away as all of the results are 
> returned
> by the server. However with cursor you have to wait until you fetch the
> rows before you can get the CommandComplete message which btw is wrong 
> as
> it returns INSERT 0 0 instead of INSERT 2 0

To make sure I am following, was this describing a comparison of
two different ways in Java, using JDBC, to perform the same operation,
one of which behaves as desired while the other doesn't? If so, for
my curiosity, what do both ways look like in Java?

Or was it a comparison of two different operations, say one
an INSERT RETURNING and the other something else?

Regards,
-Chap



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Allowing parallel-safe initplans
Next
From: Dave Cramer
Date:
Subject: Re: CommandStatus from insert returning when using a portal.