Re: Daylight Saving Time

Magnus Hagander wrote:
> On Tue, Jan 30, 2007 at 05:17:45PM -0500, Bruce Momjian wrote:
> > Magnus Hagander wrote:
> > > On Tue, Jan 30, 2007 at 02:21:21PM -0700, Match(dot)Grun(at)thomson(dot)com wrote:
> > > > As you may know, DST in the US has been changed from 2007. On March 11
> > > > we begin DST.
> > > >
> > > > I have searched the Postgres site, but there is no reference to
> > > > potential issues that may be caused by this. Also, since the Solaris
> > > > port built with the Sun Compiler did have an issue with a Horology test
> > > > case, maybe the PORTS team have most experience with this issue?
> > >
> > > I beleive you are safe as long as you are on the latest versoins -
> > > you'll need 8.2.1, 8.1.6 or 8.0.10.
> > >
> > > Bruce - given that the actual change-time is coming up, how about we add
> > > this one to the FAQ? If it isn't now, it's bound to become.
> >
> > Uh, I can. I can remember three questions. The problem is that there
> > is a lag between me adding it to the FAQ and people actually seeing it.
> > Is it worth a try?
>
> I think so. It'll get visible on google searches fairly soon, and we
> still have over a month :-) So yeah, go for it IMHO.

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>

> (I assume you're not tlaking about the technical lag of a couple of
> hours until it shows up on the website)

Right.

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +