Re: Year 2038 Bug?

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Year 2038 Bug?
Date: 2008-10-13 18:57:29
Message-ID: 738808EF-B132-47F3-B437-CCEE7F043E95@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Oct 13, 2008, at 11:53, Tom Lane wrote:

>> Oh. Is it not preferable to use the tzdata that ships with
>> PostgreSQL?
>
> Not necessarily; the system might have a more up-to-date tzdata.

Gotcha.

> Generally you'd use --with-system-tzdata on a platform where you
> expect
> to receive routine package updates for the tzdata files, independently
> of the Postgres release cycle. It seems reasonable to assume that
> anyone currently shipping tzdata is offering 64-bit files. (But we do
> have that regression test check in there to make sure.)

Understood. Thanks for the explanation (and the regression test!).

Best,

David

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeff Davis 2008-10-13 19:18:07 Re: TODO item: adding VERBOSE option to CLUSTER [with patch]
Previous Message Tom Lane 2008-10-13 18:53:28 Re: Year 2038 Bug?