Back before 8.2 came out, I posted: > Any view over the full timezone names should also include the > corresponding data from zone.tab in the timezone library source.
I got no meaningful response to this (Tom responded with an erroneous statement and ignored my explanation of his mistake). Back before 8.3 came out, Naz Gassiep posted on the same subject: http://archives.postgresql.org/pgsql-hackers/2008-01/msg00217.php and got no response at all. He posted again: http://archives.postgresql.org//pgsql-hackers/2008-02/msg00552.php and got no meaningful response. About every third month, I end up explaining on IRC to some unfortunate user that the information he needs _is_ available, but only by extracting zone.tab from the source and loading it up into a table. At the VERY LEAST, can we PLEASE have the zone.tab file INSTALLED WHERE IT BELONGS rather than simply ignored, so that even if further requests to include the information in a system view go unheard by -hackers, I can at least provide a pgfoundry module or something to do the job. To answer the inevitable responses preemptively: 1) The data in zone.tab is needed any time you want to offer a user a sensible way of choosing his timezone; it associates timezones with countries and provides additional detail for certain annoying edge cases. 2) zone.tab does not include every alias name that shows up in pg_timezone_names. IT'S NOT SUPPOSED TO INCLUDE THEM. 3) zone.tab _IS_ maintained just as carefully as the rest of the data. I don't know exactly what needs to be changed on the Windows side (where it is arguably even _more_ important to do this), but for everyone else, see the attached patch. -- Andrew (irc:RhodiumToad)
Index: src/timezone/Makefile =================================================================== RCS file: /projects/cvsroot/pgsql/src/timezone/Makefile,v retrieving revision 1.31 diff -c -r1.31 Makefile *** src/timezone/Makefile 6 Jan 2009 02:25:29 -0000 1.31 --- src/timezone/Makefile 6 Apr 2009 23:42:42 -0000 *************** *** 52,57 **** --- 52,58 ---- install: all installdirs ifeq (,$(with_system_tzdata)) $(ZIC) -d '$(DESTDIR)$(datadir)/timezone' -p '$(POSIXRULES)' $(TZDATAFILES) + $(INSTALL_DATA) '$(srcdir)/data/zone.tab' '$(DESTDIR)$(datadir)/timezone' endif $(MAKE) -C tznames $@
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
