Re: BUG #5658: 'at time zone {timezone description}' can't recognize many time zone abbreviations.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sangmin Ryu" <neocoin(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #5658: 'at time zone {timezone description}' can't recognize many time zone abbreviations.
Date: 2010-09-15 19:15:59
Message-ID: 23170.1284578159@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Sangmin Ryu" <neocoin(at)gmail(dot)com> writes:
> 'at time zone {timezone description}' don't recognize many time zone
> abbreviations.

This is configurable. See
http://www.postgresql.org/docs/8.4/static/datetime-config-files.html

In general our intent is not to try to put every timezone abbreviation
in the world into the default list of abbreviations. That would mostly
have the effect of losing error-checking capability. It's better to
have a fairly short list of abbreviations your users might actually use.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2010-09-15 21:25:39 small hstore bugfixes for 9.0 (w/patch)
Previous Message Sangmin Ryu 2010-09-15 18:36:03 BUG #5658: 'at time zone {timezone description}' can't recognize many time zone abbreviations.