Re: Considering an upgrade...

On Oct 11, 2005, at 3:07 PM, Florian G. Pflug wrote:

> On the whole, the update as quite easy ride, but I'd still
> recommend you to test all aspects
> of your software after the migration, since 8.0 isn't bug-for-bug
> compatible with 7.4
>

I'll second this. One thing we found out too, was we also upgrade
DBD::Pg which introduced some incompatibilities with respect to
placeholders. They are now always treated as strings unless
otherwise specified, and that doesn't always work with Pg 8.0.

Our specific case was a query that did something like this:

CURRENT_DATE - ?

if the parameter is substituted as '3' it fails, but just plain 3
works. So watch for things like this too.