Re: BUG #5658: 'at time zone {timezone description}' can't recognize many time zone abbreviations. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5658: 'at time zone {timezone description}' can't recognize many time zone abbreviations.
Date
Msg-id 23170.1284578159@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5658: 'at time zone {timezone description}' can't recognize many time zone abbreviations.  ("Sangmin Ryu" <neocoin@gmail.com>)
List pgsql-bugs
"Sangmin Ryu" <neocoin@gmail.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

pgsql-bugs by date:

Previous
From: "Sangmin Ryu"
Date:
Subject: BUG #5658: 'at time zone {timezone description}' can't recognize many time zone abbreviations.
Next
From: Andrew Gierth
Date:
Subject: small hstore bugfixes for 9.0 (w/patch)