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@momjian.us
  Homepage        http://momjian.us
  EnterpriseDB    http://www.enterprisedb.com
  + If your life is a hard drive, Christ can be your backup. +