Joe Conway <mail@joeconway.com> writes:
> 1. Two functions were left in the 8.4 database
> pg_toasttbl_drop(oid)
> pg_toasttbl_recreate(oid, oid)
This is pg_migrator's fault --- it should probably clean those up
when it's done.
> 3. All timestamps in the data that have two decimal places on seconds,
> but end with zero, in the 8.3 dump become one decimal place in the
> 8.4 dump
> I have to apologize for missing it if this has been discussed already,
> but was this change intentional, and if so is there any way to force the
> old behavior?
Yes, it was intentional. The discussion about changing it was
around here:
http://archives.postgresql.org/pgsql-hackers/2008-10/msg00394.php
There's no exposed way to undo it, but you could probably revert the
logic change in TrimTrailingZeros() until you'd convinced yourself
things were okay.
regards, tom lane