Remove hard-wired lists of timezone abbreviations in favor of providing

Tom Lane <tgl@sss.pgh.pa.us>

Commit: d8b5c95ca8a2ce7cd4062d4a12710ca977bac87c
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2006-07-25T03:51:23Z
Releases: 8.2.0
Remove hard-wired lists of timezone abbreviations in favor of providing
configuration files that can be altered by a DBA.  The australian_timezones
GUC setting disappears, replaced by a timezone_abbreviations setting (set this
to 'Australia' to get the effect of australian_timezones).  The list of zone
names defined by default has undergone a bit of cleanup, too.  Documentation
still needs some work --- in particular, should we fix Table B-4, or just get
rid of it?  Joachim Wieland, with some editorializing by moi.

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +53 −1
doc/src/sgml/config.sgml modified +11 −10
doc/src/sgml/datetime.sgml modified +128 −73
doc/src/sgml/ref/show.sgml modified +1 −2
src/backend/catalog/system_views.sql modified +6 −1
src/backend/utils/adt/datetime.c modified +168 −390
src/backend/utils/misc/guc.c modified +37 −13
src/backend/utils/misc/Makefile modified +2 −2
src/backend/utils/misc/postgresql.conf.sample modified +7 −1
src/backend/utils/misc/tzparser.c added +461 −0
src/include/catalog/catversion.h modified +2 −2
src/include/catalog/pg_proc.h modified +3 −1
src/include/utils/datetime.h modified +5 −1
src/include/utils/guc.h modified +1 −5
src/include/utils/tzparser.h added +35 −0
src/test/regress/expected/horology.out modified +0 −2
src/test/regress/expected/rules.out modified +2 −1
src/test/regress/expected/timestamp.out modified +0 −2
src/test/regress/expected/timestamptz.out modified +0 −2
src/test/regress/pg_regress.c modified +4 −3
src/test/regress/sql/horology.sql modified +0 −2
src/test/regress/sql/timestamp.sql modified +0 −2
src/test/regress/sql/timestamptz.sql modified +0 −2
src/timezone/Makefile modified +3 −1
src/timezone/README modified +6 −0
src/timezone/tznames/Africa.txt added +168 −0
src/timezone/tznames/America.txt added +291 −0
src/timezone/tznames/Antarctica.txt added +37 −0
src/timezone/tznames/Asia.txt added +236 −0
src/timezone/tznames/Atlantic.txt added +92 −0
src/timezone/tznames/Australia added +33 −0
src/timezone/tznames/Australia.txt added +59 −0
src/timezone/tznames/Default added +702 −0
src/timezone/tznames/Etc.txt added +33 −0
src/timezone/tznames/Europe.txt added +207 −0
src/timezone/tznames/India added +12 −0
src/timezone/tznames/Indian.txt added +35 −0
src/timezone/tznames/Makefile added +30 −0
src/timezone/tznames/Pacific.txt added +100 −0
src/timezone/tznames/README added +18 −0