Re: Timezone database changes - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Timezone database changes
Date
Msg-id 200710091704.39559.peter_e@gmx.net
Whole thread Raw
In response to Re: Timezone database changes  ("Trevor Talbot" <quension@gmail.com>)
Responses Re: Timezone database changes
Re: Timezone database changes
List pgsql-hackers
Am Dienstag, 9. Oktober 2007 schrieb Trevor Talbot:
> I don't think it's wrong, just a particular choice.  As an example,
> consider an interval scheduling system that handles everything in
> absolute time (UTC), but uses local time as a convenience.

We are not considering an interval scheduling system, we are considering a 
database system.  Such a system should have the basic property that if you 
store A, it will read out as A.  The money type is similarly buggy: if you 
change the locale, the semantic value of the data changes.  With money type, 
the problem is obvious and easy to recognize.  With the timestamp with time 
zone type, however, the problem is much more subtle and will likely go 
unnoticed by many who will then be unpunctual for their appointments.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Timezone database changes
Next
From: Simon Riggs
Date:
Subject: Re: Uninformative messages from pg_ctl