pg.ddx.io  pgsql-hackers-win32@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Lane Van Ingen <lvaningen@ESNCC.com>
Cc: Obe, Regina DND\\MIS <robe.dnd@cityofboston.gov>
Cc: pgsql-hackers-win32@postgresql.org
Subject: Re: Server Time Setting
Date: Thu, 15 Sep 2005 12:07:26 -0400
Message-ID: <43299C3E.50603@dunslane.net> (raw)
In-Reply-To: <14438.1126799474@sss.pgh.pa.us>
References: <EKEMKEFLOMKDDLIALABIKEJOCCAA.lvaningen@esncc.com>
	<14438.1126799474@sss.pgh.pa.us>



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



view thread (9+ messages)  latest in thread

Message-ID: <43299C3E.50603@dunslane.net>
Permalink:  ../43299C3E.50603@dunslane.net/
Also on:    postgresql.org/message-id/43299C3E.50603@dunslane.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-hackers-win32@postgresql.org
  Cc: andrew@dunslane.net, tgl@sss.pgh.pa.us, lvaningen@ESNCC.com, robe.dnd@cityofboston.gov
  Subject: Re: Server Time Setting
  In-Reply-To: <43299C3E.50603@dunslane.net>
  References: <EKEMKEFLOMKDDLIALABIKEJOCCAA.lvaningen@esncc.com> <14438.1126799474@sss.pgh.pa.us> <43299C3E.50603@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox