Just did a big upgrade to our Postgres system while moving it to a faster server. There were some gotchas.
- No longer silently truncates input to table field length (i.e. stuffing 60 characters into a varchar(50) generates an error now)
- No longer coerces '' to 0 when an integer is expected
- No longer treats timestamp(N) as producing a date and time matching what Unix's time(N) would; you have to use abstime(N) now
The cool new features are so worth it, though.