"" <tcook(at)blackducksoftware(dot)com> writes: > It looks like pg_timezone_abbrevs is missing some entries?
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 :-(
In the meantime, why aren't you just using clock_timestamp()? timeofday() is deprecated.