Re: timestamp skew during 7.4 -> 8.2 upgrade

Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> On Fri, Aug 10, 2007 at 10:11:29AM +0200, Louis-David Mitterrand wrote:
>> So if I understand correctly, a timestamp_tz is ...

> ... stored as UTC in the backend

> ... sent to clients shifted by whatever timezone was
> requested by the client by one of several mechanisms:

> - "set timezone to ..." used by the client
> - "select ... at time zone ..." used by the client
> - the server timezone if neither of the above is used

The other point to be clear on is that the "shifting" is done according
to whatever timezone rule files the server currently has. Since
politicians keep changing daylight-savings rules, the same UTC date/time
might be displayed differently after an update of the relevant rule
file.

regards, tom lane