On Mon, Aug 1, 2011 at 8:12 AM, Atul Goel <Atul.Goel@iggroup.com> wrote:
> Hi Forum,
>
> We are planning to upgrade a postgres 8.0 database to postgres 9.0 (Actually
> already done in Dev). The application is J2EE application with Hibernate. My
> question are
>
> 1) Is there a list of things that needs to be taken care while
> upgrading(known issues).
The single greatest issue is that implicit casts have been removed.
This means you can't do things like use substring on a date type etc
directly or match an int to a varchar in a join without an explicit
cast of one to the other.