I think all we need to do is to change "timestamp" to "timestamptz" ("timestamp_tz", whatever the hell it is called) in the sources. This fill fix new installs. This would be easier than trying to rewrite a bunch of code, which might extend to users of OACS 4.5 having to rewrite code.
For dump-restore from PG 7.2 to PG 7.3 at the moment my fingers are crossed that in PG 7.2 they really entered the type as "timestamptz" and that the dump-restore will work for this reason. If it doesn't we're in trouble (and if it does using timestamptz in the sources for new installs makes even more sense).
But I've not tried it. I don't think we should worry about it for 4.6. If the dump behavior doesn't work as I outline above we're going to be screwed so let's cross our fingers. If it does work it's easy to edit the files.
