Re: Postgres 8.0 upgrade to 9.0 - Mailing list pgsql-general

From Hannes Erven
Subject Re: Postgres 8.0 upgrade to 9.0
Date
Msg-id 4E36F933.9000004@erven.at
Whole thread Raw
In response to Postgres 8.0 upgrade to 9.0  (Atul Goel <Atul.Goel@iggroup.com>)
List pgsql-general
Atul,


> 2)      Do I need to upgrade JDBC driver when I upgrade to postgres9.0.

Yes, at least if you use BLOB types. The 9.0 server sends them in a
format former JDBC drivers cannot understand:
http://www.postgresql.org/docs/9.0/static/runtime-config-client.html#GUC-BYTEA-OUTPUT

Other than that I did not experience issues, but the application I
support was upgraded from only 8.3 to 9.0 (and is running now on 9.0 for
many months flawlessly).


Best regards,

    -hannes

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Postgres 8.3 Function returning a row with different number of colums
Next
From: Tom Lane
Date:
Subject: Re: Pending trigger events on ALTER TABLE in 8.3