Re: Daylight Saving Time

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Match(dot)Grun(at)thomson(dot)com, pgsql-ports(at)postgresql(dot)org
Subject: Re: Daylight Saving Time
Date: 2007-01-31 00:16:35
Message-ID: 13632.1170202595@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Bruce Momjian <bruce(at)momjian(dot)us> writes:
> OK, added FAQ item:

> <H3 id="item1.14">1.14) Will PostgreSQL handle recent daylight
> saving time changes in various countries?</H3>

> <P>PostgreSQL versions prior to 8.0 use the operating system's
> timezone database for daylight saving information. All current
> versions of PostgreSQL 8.0 and later contain up-to-date timezone
> information.</P>

This fails to answer the question, as you already found out. You need
to say *which* versions contain which updates. I believe a useful
answer will include these facts:

2007 USA changes:
8.0.4 and later, all 8.1.x and up
2007 Canada and Western Australia changes:
8.0.10 and later, 8.1.6 and later, all 8.2.x and up

regards, tom lane

In response to

Browse pgsql-ports by date

  From Date Subject
Next Message Marc Simonin 2007-01-31 13:19:12 Multiple Crashs on OSX Intel
Previous Message Match.Grun 2007-01-30 23:58:34 Re: Daylight Saving Time