OSDN Git Service

Remove hard-wired lists of timezone abbreviations in favor of providing
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 25 Jul 2006 03:51:23 +0000 (03:51 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 25 Jul 2006 03:51:23 +0000 (03:51 +0000)
commitd8b5c95ca8a2ce7cd4062d4a12710ca977bac87c
treea22dd25471942e3a24edcc2319e03319bed0482b
parent631ea6188366ee1b9818fed88d8fadd495246fd7
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.
40 files changed:
doc/src/sgml/catalogs.sgml
doc/src/sgml/config.sgml
doc/src/sgml/datetime.sgml
doc/src/sgml/ref/show.sgml
src/backend/catalog/system_views.sql
src/backend/utils/adt/datetime.c
src/backend/utils/misc/Makefile
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/backend/utils/misc/tzparser.c [new file with mode: 0644]
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/include/utils/datetime.h
src/include/utils/guc.h
src/include/utils/tzparser.h [new file with mode: 0644]
src/test/regress/expected/horology.out
src/test/regress/expected/rules.out
src/test/regress/expected/timestamp.out
src/test/regress/expected/timestamptz.out
src/test/regress/pg_regress.c
src/test/regress/sql/horology.sql
src/test/regress/sql/timestamp.sql
src/test/regress/sql/timestamptz.sql
src/timezone/Makefile
src/timezone/README
src/timezone/tznames/Africa.txt [new file with mode: 0644]
src/timezone/tznames/America.txt [new file with mode: 0644]
src/timezone/tznames/Antarctica.txt [new file with mode: 0644]
src/timezone/tznames/Asia.txt [new file with mode: 0644]
src/timezone/tznames/Atlantic.txt [new file with mode: 0644]
src/timezone/tznames/Australia [new file with mode: 0644]
src/timezone/tznames/Australia.txt [new file with mode: 0644]
src/timezone/tznames/Default [new file with mode: 0644]
src/timezone/tznames/Etc.txt [new file with mode: 0644]
src/timezone/tznames/Europe.txt [new file with mode: 0644]
src/timezone/tznames/India [new file with mode: 0644]
src/timezone/tznames/Indian.txt [new file with mode: 0644]
src/timezone/tznames/Makefile [new file with mode: 0644]
src/timezone/tznames/Pacific.txt [new file with mode: 0644]
src/timezone/tznames/README [new file with mode: 0644]