Re: daylight savings patches needed?

Ed L. wrote:
>
> >From the FAQ:
>
> ====================
> 1.14) Will PostgreSQL handle recent daylight saving time changes
> in various countries?
>
> 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.
> ====================
>
> In this context, assuming we have applied the relevant OS patches
> (RHEL, Debian, HPUX 11.11, 11.23), does the phrase "contain
> up-to-date timezone information" mean that all 7.[234].x and 8.x
> installations are prepared to properly handle the March 1, 2007
> DST changes in the US? If not, what is needed?

I was trying to avoid getting into the gory details of which releases
had which timezone fixes, but it seems I can't avoid it. The new FAQ
item has the details:

USA daylight saving time changes are included in PostgreSQL release
8.0.[4+], and all later major releases, e.g. 8.1. Canada and Western
Australia changes are included in 8.0.[10+], 8.1.[6+], and all later
major releases. PostgreSQL releases prior to 8.0 use the operating
system's timezone database for daylight saving information.

If this is unclear, please let me know.

--
Bruce Momjian bruce(at)momjian(dot)us
Homepage http://momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +