Re: PGStatement#setPrepareThreshold

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Csaba Nagy <nagy(at)ecircle-ag(dot)com>, Postgres JDBC <pgsql-jdbc(at)postgresql(dot)org>, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: PGStatement#setPrepareThreshold
Date: 2006-08-03 22:14:48
Message-ID: 44D27558.3040907@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2006-08-03 22:20:47 Re: PGStatement#setPrepareThreshold
Previous Message Dave Cramer 2006-08-03 22:07:25 Re: PGStatement#setPrepareThreshold