Re: Timezone database changes

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/

In response to

Responses

Browse pgsql-hackers by date

  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