From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
Cc: | Naz Gassiep <naz(at)mira(dot)net>, pgsql-hackers(at)postgresql(dot)org, Joachim Wieland <joe(at)mcknight(dot)de> |
Subject: | Re: Timezone List |
Date: | 2006-09-06 19:01:27 |
Message-ID: | 22922.1157569287@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> In the CVS version there is a table with this information:
> http://developer.postgresql.org/pgdocs/postgres/view-pg-timezonenames.html
Actually, what that view gives you is timezone offset abbreviations, not
the full zone names that you could use with SET TIME ZONE. It strikes
me that we should have a view for that as well. We could use code
similar to scan_available_timezones() to generate the view output.
It's somewhat urgent to address this now, because pg_timezonenames is
sitting on the obvious name for such a view, and once we release 8.2
we won't be able to change it. On reflection I think the existing view
is wrongly named --- perhaps it should be pg_timezoneabbrevs? Or
more readably, perhaps pg_timezone_abbrevs, with pg_timezone_names for
the other view.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Kaltenbrunner | 2006-09-06 19:13:34 | Re: ECPG/OpenBSD buildfarm failures, take I |
Previous Message | Tom Lane | 2006-09-06 18:55:01 | Re: Timezone List |
From | Date | Subject | |
---|---|---|---|
Next Message | Naz Gassiep | 2006-09-06 19:29:04 | Re: Timezone List |
Previous Message | Tom Lane | 2006-09-06 18:55:01 | Re: Timezone List |