"Joachim Wieland" <[EMAIL PROTECTED]> writes:
> Here's the patch that generalizes the australian_timezones hack by moving the
> compiled-in time zone definitions into a text file. The text file to use is
> chosen via a guc.
Applied with some revisions --- mostly, that I didn't like restricting
timezone_abbreviations to be changed only via postgresql.conf. The old
australian_timezones setting was always USERSET, and I think people
would have had a legitimate gripe about loss of flexibility if its
replacement wasn't. Fortunately this wasn't too hard to change. I also
editorialized a bit on the file placement and the parsing code.
The documentation is still in need of help ... in particular, Table B-4
(timezone names) is now out of sync with reality. I am not sure whether
to try to fix it, or just remove it and tell people to look at the
pg_timezonenames view. Thoughts? If you want to fix it, please send
a patch.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match