On Wed, 13 Feb 2008, Josh Berkus wrote:
> Since JDBC always prepares and plan-caches queries, it makes it hard to use
> partitioning with a database connected to a JDBC connection pool; successive
> queries in the same session will select the wrong partition, or scan the
> whole partition set.
>
It will never scan the wrong partition. It will always scan all
partitions. The server is smart enough to not generate a plan that is not
valid for only one parameter set.
Using protocol version 2 will not prepare queries so constraint exclusion
can be used. Just append protocolVersion=2 to your URL.
Kris Jurka