X-Original-To: pgsql-hackers-win32-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C5282D8FA9 for ; Thu, 15 Sep 2005 13:07:41 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67496-02 for ; Thu, 15 Sep 2005 16:07:37 +0000 (GMT) Received: from trolak.mydnsbox2.com (ns1.mydnsbox2.com [207.44.142.118]) by svr1.postgresql.org (Postfix) with ESMTP id D201ED8FC0 for ; Thu, 15 Sep 2005 13:07:37 -0300 (ADT) Received: from [192.168.1.103] (cpe-024-211-165-134.nc.res.rr.com [24.211.165.134]) (authenticated (0 bits)) by trolak.mydnsbox2.com (8.11.6/8.11.6) with ESMTP id j8FFNNu28586; Thu, 15 Sep 2005 10:23:23 -0500 Message-ID: <43299C3E.50603@dunslane.net> Date: Thu, 15 Sep 2005 12:07:26 -0400 From: Andrew Dunstan User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.10) Gecko/20050909 Fedora/1.7.10-1.3.2 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Lane Van Ingen , "Obe, Regina DND\\MIS" , pgsql-hackers-win32@postgresql.org Subject: Re: Server Time Setting References: <14438.1126799474@sss.pgh.pa.us> In-Reply-To: <14438.1126799474@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 required=5 tests=[AWL=0.040] X-Spam-Level: X-Archive-Number: 200509/29 X-Sequence-Number: 3395 Tom Lane wrote: >Hmm. I think the way that the code in pgtz.c is set up, it just assumes >that either "Eastern Standard Time" or "Eastern Daylight Time" should >map to our US/Eastern timezone (which is a DST-aware zone). Running >your system in non-DST-aware mode is what's confusing it --- the offset >to GMT is an hour different than it "should be" at this time of year. > >Should pgtz.c try to detect this situation and handle it by mapping to a >non-DST-aware internal timezone? > > > > I think this is a simple case of misconfiguration and I suspect fiddling with it would just open up the possibility of more errors. If you say you are in a DST timezone and you don't check the DST checkbox, and you set the time to summer time then you're asking for trouble. I would not be at all surprised if the machine's idea of UTC was an hour out (Windows boxes keep the RTC on local time, not UTC, which is just horrid). cheers andrew