Tom Lane wrote:
Rick Schumeyer <rschumeyer@xxxxxxxx> writes:
I'm working with someone who is about to upgrade from (I believe) pg 7.4
to pg 8.1.
What would be the best resource to read to look for "gotchas"? Release
notes? At the moment, we don't care about performance problems, only
things that might break.
Reading the release notes is good, but you really really should test the
application(s) against a test 8.1 installation before you go live ...
regards, tom lane
We plan on testing. I'm asking if there is anything that "everyone
knows" will break that we might as well fix before testing.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
