> > 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
> 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
> 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 wit
> > 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.
> Did that.
Great!
> But given that 'timestamp' is really
Thomas Lockhart writes:
> 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.
>
> Comments? Would a pg_dump guru be willi
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.
Comments? Would a pg_dump guru be willing to take this on? Should be
"easy"