AW: timestamp in pg_dump

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'lockhart(at)fourpalms(dot)org'" <lockhart(at)fourpalms(dot)org>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: timestamp in pg_dump
Date: 2001-02-06 10:38:47
Message-ID: 11C1E6749A55D411A9670001FA6879633681E9@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Devik 2001-02-06 11:33:24 optimizer/planner ideas
Previous Message Peter T Mount 2001-02-06 10:23:16 Re: Postgre SQL for Windows