Re: Timezone List - Mailing list pgsql-hackers

From Naz Gassiep
Subject Re: Timezone List
Date
Msg-id 44FF159A.7050201@mira.net
Whole thread Raw
In response to Re: Timezone List  (Martijn van Oosterhout <kleptog@svana.org>)
Responses Re: Timezone List  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Martijn van Oosterhout wrote:
> In the CVS version there is a table with this information:
>
> http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html 
>
>   
Great, thanks for that
> Err, where does postgres use this information? I beleive there is a
> project on pgfoundary that has some standard datasets.
>   
Currently, it is stored in /src/timezone/data/iso3166.tab and I propose 
to have it available in a system view or something similar. This data is 
as useful as the available timezones, although I concede that it is not 
part of PG functionality and this may be more appropriate as a simple 
file that can be psql -f'd into the database if users need it as part of 
an app. It's more "developer helper data" than "database functionlity" 
and hence it could be more appropriate to distribute through the support 
community rather than as part of the postgresql core.

Comments?


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Timezone List
Next
From: Michael Paesold
Date:
Subject: Re: Open items for 8.2