Re: PGStatement#setPrepareThreshold - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: PGStatement#setPrepareThreshold
Date
Msg-id 44D27558.3040907@opencloud.com
Whole thread Raw
In response to Re: PGStatement#setPrepareThreshold  (Dave Cramer <pg@fastcrypt.com>)
Responses Re: PGStatement#setPrepareThreshold  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
Dave Cramer wrote:

> If that's the case then the driver is not doing what it's supposed to be
> doing. It should be using the named portal (S_3) to do the insert.

No, the driver is fine. It is using a named statement (S_3) but an
unnamed portal (because it is going to fetch all the data in one go and
doesn't need to retain the portal after execution)

If your query met the conditions for using a portal-based ResultSet,
you'd see it use a named portal as well as a named statement.

-O

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: PGStatement#setPrepareThreshold
Next
From: Dave Cramer
Date:
Subject: Re: PGStatement#setPrepareThreshold