Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7E7D49FB48E for ; Thu, 1 Mar 2007 16:30:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 10786-06 for ; Thu, 1 Mar 2007 16:30:43 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail1.livedatagroup.com (mail1.livedatagroup.com [216.154.205.166]) by postgresql.org (Postfix) with ESMTP id 6BC719FB367 for ; Thu, 1 Mar 2007 16:30:44 -0400 (AST) Message-ID: <45E737EF.7090709@livedatagroup.com> Date: Thu, 01 Mar 2007 15:30:39 -0500 From: Pallav Kalva MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Day Light Savings Problem Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/3 X-Sequence-Number: 24827 Hi, As per this article http://people.planetpostgresql.org/greg/index.php?url=archives/96-Is-your-database-ready-for-the-Daylight-Savings-Times-change-of-2007.html&serendipity[cview]=linear#comments, My postgres 8.0.2 database has a problem with the new day light savings time change this month. So, I upgraded it to the latest 8.0 version which is 8.0.12 and below you will see the output of the case statement and also the timezone file. As you can see the case statement says that timezone value is fixed but where as the timezone file still has the old values. Is this a bug ? why cant it show the new timezone values in the timezone file ? I even looked at the 8.2.1 timezone file it also has the old values. Can I use this postgres 8.0.12 version for the day light savings problem. =========================================================== postgres@pkalva:/var/lib/pgsql/bin> ./psql template1 Welcome to psql 8.0.12, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help with psql commands \g or terminate with semicolon to execute query \q to quit template1=# SET TIMEZONE = 'EST5EDT'; SET template1=# template1=# SELECT CASE WHEN template1-# timestamptz '20070401 0100' template1-# + interval '1 hour' template1-# >= '20070401 0300' template1-# THEN 'Wrong' ELSE 'Right' END; case ------- Right (1 row) template1=# \q postgres@pkalva:/var/lib/pgsql/bin> cd .. postgres@pkalva:/var/lib/pgsql> cd share postgres@pkalva:/var/lib/pgsql/share> /usr/sbin/zdump -v EST5EDT | grep 2007 EST5EDT Sun Apr 1 06:59:59 2007 UTC = Sun Apr 1 01:59:59 2007 EST isdst=0 gmtoff=-18000 EST5EDT Sun Apr 1 07:00:00 2007 UTC = Sun Apr 1 03:00:00 2007 EDT isdst=1 gmtoff=-14400 EST5EDT Sun Oct 28 05:59:59 2007 UTC = Sun Oct 28 01:59:59 2007 EDT isdst=1 gmtoff=-14400 EST5EDT Sun Oct 28 06:00:00 2007 UTC = Sun Oct 28 01:00:00 2007 EST isdst=0 gmtoff=-18000