Re: daylight savings patches needed? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: daylight savings patches needed?
Date
Msg-id 200702061852.l16IqTY04378@momjian.us
Whole thread Raw
In response to daylight savings patches needed?  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: daylight savings patches needed?
List pgsql-general
Steve Crawford wrote:
> > 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.
> >
>
> Don't know if this was asked/answered elsewhere but:
>
> 1. What, exactly, was the point of moving away from the system zoneinfo
> files and requiring PG admins to maintain yet another apparently
> identical set of files? It seemed to work fine as it was and for me this
> change just adds more work and chance of error.

We needed more control of how to query that database for timestamp
support.

> 2. Is there a build option to put it back to the old way?

No.

> 3. If 2.answer=no then would there be any problem just symlinking the PG
> timezone directory to the system zoneinfo directory?

Uh, I think you could do that, yea, assuming the same binaries could be
used.  Remember, it doesn't read the text files but binary representations.

--
  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. +

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: daylight savings patches needed?
Next
From: Tom Lane
Date:
Subject: Re: daylight savings patches needed?