Regarding #1, PG 7.2.1 allows specification of the precision, so you can use a datatype of timestamp(0). Selections from columns so defined will have no precision on them, just like previous versions of Postgresql. Perhaps this is where the change should be made instead of fixing code in other places.
