Re: TimeZone List

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Naz Gassiep <naz(at)mira(dot)net>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: TimeZone List
Date: 2007-05-30 02:38:11
Message-ID: 23806.1180492691@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Naz Gassiep <naz(at)mira(dot)net> writes:
> Ok, that's kinda cool. But can I trust those names to not change from
> version to version?

No, you can't. The reason there is no "nonvolatile" list of timezones
is that timezones are subject to the whims of politicians, who can and
do change them at the drop of a hat. Read the historical comments in
the zic source files sometime...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mageshwaran 2007-05-30 02:45:11 Problem with timestamp
Previous Message Francisco Reyes 2007-05-30 02:35:09 Re: Delete with subquery deleting all records