Re: Upgrade to 9 questions

On Fri, 1 Oct 2010, Kevin Grittner wrote:

>> Anybody could comment on the other one, about the version
>> compatibility?
>
> This currently recommends 9.0-801 for PostgreSQL version 7.2 or
> newer. I seem to remember some compatibility problems with using
> the older driver against 9.0, although I don't remember what the
> issues were. I would be particularly skeptical about using an older
> JDBC jar against 9.0 if you care about the JDBC metadata objects.
> (It's hard for an old driver to know what future releases are doing
> with the system tables.)
>

Aside from metadata changes, the key change that needs a new JDBC driver
for a 9.0 server is the format of bytea data. You need to use the new
JDBC driver or to adjust your server settings to return bytea data in the
old format or you will silently get corrupt data.

Kris Jurka