> I'd like to have pg_dump for 7.1 produce "timestamp with time zone" when
> dealing with timestamp type(s). That will prepare us for introducing a
> timestamp type without time zones, while allowing reasonable upgrades to
> 7.2.
But the current timestamp does not store a timezone. timestamp with time zone
is supposed to store and output the timezone that was inserted.
The current timestamp has it messed up (sorry), since it does not store a timezone.
It stores time in UTC and always converts output to the timezone derived from [PG]TZ.
IMHO timestamp is currently closest to the ANSI timestamp without time zone.
Especially if you always omit a timezone for input and ignore the timezone that is output.
A reasonably easy upgrade is imho not possible :-(
Andreas