Re: Daylight Saving Time

[Bruce Momjian <bruce(at)momjian(dot)us>]

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