OK, thanks for the explanation.
Performance won't be an issue for me in this case as I'm not curently doing
any runtime code generation, it's just for development and the code
generator only ever uses meta data.
regards
Iain
----- Original Message -----
From: "Kris Jurka" <books@ejurka.com>
To: "Iain" <iain@mst.co.jp>
Cc: <pgsql-jdbc@postgresql.org>
Sent: Monday, December 06, 2004 7:44 PM
Subject: Re: [JDBC] meta data information returned for domains
>
>
> On Mon, 6 Dec 2004, Iain wrote:
>
>> I expect this question has been asked before but is there any reason why
>> I
>> shouldn't use the newer driver (for v8) with 7.4.6? I assume that it
>> would
>> allow me to use the getUDT method if I did that.
>>
>
> There are potentially serious performance problems with using the 8.0
> driver on a 7.4 server. The 8.0 driver uses a server prepared statement
> for every PreparedStatement object. On the server side prepared
> statements usually don't consider the actual parameter values to generate
> a query plan. This means an inferior query plan can be generated when the
> parameter values are known, but unused, and you don't intend to reuse the
> prepared statement. The 8.0 server has a mechanism to use parameter
> values for planning in certain situations that the 7.4 server does not.
>
> Kris Jurka
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
