On Mon, Aug 1, 2011 at 8:12 AM, Atul Goel <Atul.Goel@xxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general