Re: User-Friendly TimeZone List

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Naz Gassiep <naz(at)mira(dot)net>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: User-Friendly TimeZone List
Date: 2007-08-16 05:28:11
Message-ID: 17581.1187242091@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:
> 1. The timezone list there isn't exactly user friendly, there are many
> Etc/* timezones there, as well as others that would be potentially
> confusing for users who are trying to select the timezone they are in.

Feel free to filter things you don't think are popular. I'd be inclined
to delete Etc/ posix/ and right/ (the latter two only show up on some
platforms). Another idea is to not show anything more than an hour or
two off from where you think the user is.

> 2. If a timezone is removed from the list for whatever reason, then the
> system will be left with users who have selected a timezone that is no
> longer a valid choice in the list.

I think that's pretty unlikely to happen, unless you switch to a
different platform.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-16 05:31:46 Re: SELECT ... FOR UPDATE performance costs? alternatives?
Previous Message Tom Lane 2007-08-16 05:21:43 Re: Deadlocks caused by a foreign key constraint