Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones
Date
Msg-id 20080827014719.GV4920@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones
List pgsql-bugs
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.1219793881@sss.pgh.pa.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.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones
Next
From: Tom Lane
Date:
Subject: Re: BUG #4377: casting result of timeofday() to timestamp fails in some timezones