Re: New US DST Rules & PostgreSQL

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adam Gordon <adam(dot)gordon(at)readytalk(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: New US DST Rules & PostgreSQL
Date: 2007-01-23 06:18:49
Message-ID: 10860.1169533129@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adam Gordon <adam(dot)gordon(at)readytalk(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message stevegy 2007-01-23 07:10:27 Re: &nbsp;&nbsp;The&nbsp;jdbc
Previous Message Tom Lane 2007-01-23 05:59:38 Re: Regular expressions and arrays and ANY() question