Postgres Pro
Downloads
Home   >   mailing lists

Re: New US DST Rules & PostgreSQL - Mailing list pgsql-general

From Tom Lane
Subject Re: New US DST Rules & PostgreSQL
Date
Msg-id 10860.1169533129@sss.pgh.pa.us
Whole thread Raw
In response to New US DST Rules & PostgreSQL  (Adam Gordon <adam.gordon@readytalk.com>)
List pgsql-general
Tree view 
Adam Gordon <adam.gordon@readytalk.com> writes:
> Anyone know where to find info about whether or not the new US DST rules
> impact certain versions of Postgres and what needs to be done to ensure
> observance of the new rules?  Thanks.

http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/data/northamerica

The short version:

Any 7.x PG: uses your OS's timezone info, hence OK if you've updated the OS

8.0.x PG: need 8.0.4 or later

8.1.x PG: all releases know about 2007 US DST updates

8.2.x PG: all releases know about 2007 US DST updates

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Regular expressions and arrays and ANY() question
Next
From: Martijn van Oosterhout
Date:
Subject: Re: [HACKERS] Autovacuum Improvements