Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones

Tom Lane wrote:

> Well, it's intentional that the view not contain *every* abbrev,
> since there are conflicts. But I have noticed that the files under
> src/timezone/tznames/ seem to be missing some abbreviations that are
> in fact known in the zic database. Somebody ought to go through that
> info again sometime, first to find any missing abbrevs and second to
> see if there are more that we could safely promote into the Default
> list. It sounds like a mind-numbingly tedious task though :-(

Added to TODO:

{{TodoItemEasy
|Revise the src/timezone/tznames abbreviation files:
|
* to add missing abbreviations
* to find abbreviations that can be safely promoted to the Default list
* {{messageLink|7867(dot)1219793881(at)sss(dot)pgh(dot)pa(dot)us|BUG #4377: casting result of timeofday() to timestamp fails in some timezones}}}}

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.