On 10/04/2012 02:52 PM, Swayam Prakash Vemuri wrote:
> Hi
>
> We have an application which uses postgresql 7.4.5.
Wow. Upgrade time on two levels:
- You're running a fossilized point release. The latest 7.4.x is 7.4.30,
25 patch-levels after yours, and came out in October 2010 vs the August
2004 (!!) release date of your version. You're missing SIX YEARS OF BUG
FIXES.
- 7.4.x is unsupported. No future releases will be made with bug fixes
or compatibility improvements. Upgrade urgently, because it's only going
to get more difficult.
Read the release notes from every .0 version between 7.4 and 9.1 or 9.2
to find possible compatibility issues you may face. Pay particular
attention to the bytea_output change (if you use bytea), to
standard_conforming_strings, and to the removal of implicit casts to text.
> Now when we moved to Java 1.6, we are seeing lots of jdbc driver related
> compilation issues like shown at end of this email.
You shouldn't need to compile PgJDBC; there are pre-built binaries
provided for JDBC3 and JDBC4 versions of the platform.
You haven't said which version of PgJDBC you are updating *from* or
*to*, making it hard to help you.
The latest PgJDBC should be fine in Java 1.5, 1.6 or 1.7 and should work
against Pg 8.3 or newer, and may also work on older versions of Pg as
well. There's code in there for 7.3 and older.
You cannot reasonably expect an ancient PgJDBC to compile on a new Java,
or a new PgJDBC on a new Java to support a truly ancient Pg like 7.4.
--
Craig Ringer