All,
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.
Is there any workaround for this, either on 8.2 or 8.3?
--
Josh Berkus
PostgreSQL @ Sun
San Francisco