From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
---|---|
To: | "Trevor Talbot" <quension(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org, "Magne =?iso-8859-1?q?M=E6hre?=" <Magne(dot)Mahre(at)sun(dot)com> |
Subject: | Re: Timezone database changes |
Date: | 2007-10-09 15:04:39 |
Message-ID: | 200710091704.39559.peter_e@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2007-10-09 15:21:07 | Re: Uninformative messages from pg_ctl |
Previous Message | Kevin Grittner | 2007-10-09 14:50:44 | Re: Timezone database changes |