pg.ddx.io  pgsql-hackers-win32@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Lane Van Ingen <lvaningen@ESNCC.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-hackers-win32@postgresql.org
Subject: Re: Server Time Setting
Date: Thu, 15 Sep 2005 12:59:54 -0400
Message-ID: <4329A88A.6050308@dunslane.net> (raw)
In-Reply-To: <EKEMKEFLOMKDDLIALABIAEKACCAA.lvaningen@esncc.com>
References: <EKEMKEFLOMKDDLIALABIAEKACCAA.lvaningen@esncc.com>



Lane Van Ingen wrote:

>If I am following this correctly, I may have solved the problem for myself
>in
>the Eastern time zone, but this application gets deployed around the world,
>anywhere at sea that a vessel can go. While I think the vessel sets its time
>based on its home port and keeps it that way through voyage(s), I am won-
>dering if handling of time is still going to give me problems outside of
>time
>zones where DST is being observed.
>  
>
>  
>

If they set the machine to the home port's time and leave it there that 
should be no problem, as long as they select DST adjustment if it's a 
zone that uses DST. In fact I suspect they can set it anyway, regardless 
of TZ, because if the zone doesn't have DST nothing should happen. Test 
it and see.

The trouble with any sort of detection/correction would be that if the 
DST flag is off we have no idea whether the user has left the time on 
the zone's base and so it shows an hour's difference from actual local 
time, or if they have set it to the DST time manually and thus more or 
less lied about the value of UTC. I've seen both happen, many times.

cheers

andrew



view thread (9+ messages)

Message-ID: <4329A88A.6050308@dunslane.net>
Permalink:  ../4329A88A.6050308@dunslane.net/
Also on:    postgresql.org/message-id/4329A88A.6050308@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, lvaningen@ESNCC.com, tgl@sss.pgh.pa.us
  Subject: Re: Server Time Setting
  In-Reply-To: <4329A88A.6050308@dunslane.net>
  References: <EKEMKEFLOMKDDLIALABIAEKACCAA.lvaningen@esncc.com> <4329A88A.6050308@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