In another thread, Ben mentioned the issues he's running into with upgrading to 8.3 and lack of some of the old implicit (but wrong) type conversion. > Remember 8.3 also gives you the "opportunity" to fix all the sloppy code in > your application that depends upon implicit casting. If that's as expensive > for you to fix as it is for us, then you won't be moving to 8.3 any time > soon. What we did to fix our code was to upgrade to 8.3.3 in development first, and fix all the bugs (about 40 or 50) we could see that popped up in the sql logs regarding type mismatches. then, in production, we replaced our 8.1 slony slave with an 8.3 slony slave and set it to handle half the read load. We found another dozen or so bad sql statements doing that, and fixed and released new code that night. Then after that we swapped the 8.3 for the 8.1 server and then added the other new server, also running 8.3 to replace the 8.1 server.
