pgsql: Remove hard-wired lists of timezone abbreviations in favor of

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Remove hard-wired lists of timezone abbreviations in favor of
Date: 2006-07-25 03:51:23
Message-ID: 20060725035123.205999FA621@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Log Message:
-----------
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.

Modified Files:
--------------
pgsql/doc/src/sgml:
catalogs.sgml (r2.126 -> r2.127)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.126&r2=2.127)
config.sgml (r1.68 -> r1.69)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/config.sgml.diff?r1=1.68&r2=1.69)
datetime.sgml (r2.50 -> r2.51)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/datetime.sgml.diff?r1=2.50&r2=2.51)
pgsql/doc/src/sgml/ref:
show.sgml (r1.40 -> r1.41)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/show.sgml.diff?r1=1.40&r2=1.41)
pgsql/src/backend/catalog:
system_views.sql (r1.27 -> r1.28)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.27&r2=1.28)
pgsql/src/backend/utils/adt:
datetime.c (r1.168 -> r1.169)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/datetime.c.diff?r1=1.168&r2=1.169)
pgsql/src/backend/utils/misc:
Makefile (r1.25 -> r1.26)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/Makefile.diff?r1=1.25&r2=1.26)
guc.c (r1.328 -> r1.329)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/guc.c.diff?r1=1.328&r2=1.329)
postgresql.conf.sample (r1.183 -> r1.184)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/postgresql.conf.sample.diff?r1=1.183&r2=1.184)
pgsql/src/include/catalog:
catversion.h (r1.339 -> r1.340)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.339&r2=1.340)
pg_proc.h (r1.416 -> r1.417)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h.diff?r1=1.416&r2=1.417)
pgsql/src/include/utils:
datetime.h (r1.59 -> r1.60)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/datetime.h.diff?r1=1.59&r2=1.60)
guc.h (r1.69 -> r1.70)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/guc.h.diff?r1=1.69&r2=1.70)
pgsql/src/test/regress/expected:
horology.out (r1.61 -> r1.62)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/horology.out.diff?r1=1.61&r2=1.62)
rules.out (r1.115 -> r1.116)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.115&r2=1.116)
timestamp.out (r1.29 -> r1.30)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamp.out.diff?r1=1.29&r2=1.30)
timestamptz.out (r1.19 -> r1.20)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/timestamptz.out.diff?r1=1.19&r2=1.20)
pgsql/src/test/regress:
pg_regress.c (r1.14 -> r1.15)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/pg_regress.c.diff?r1=1.14&r2=1.15)
pgsql/src/test/regress/sql:
horology.sql (r1.32 -> r1.33)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/horology.sql.diff?r1=1.32&r2=1.33)
timestamp.sql (r1.15 -> r1.16)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/timestamp.sql.diff?r1=1.15&r2=1.16)
timestamptz.sql (r1.8 -> r1.9)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/timestamptz.sql.diff?r1=1.8&r2=1.9)
pgsql/src/timezone:
Makefile (r1.23 -> r1.24)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/Makefile.diff?r1=1.23&r2=1.24)
README (r1.4 -> r1.5)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/README.diff?r1=1.4&r2=1.5)

Added Files:
-----------
pgsql/src/backend/utils/misc:
tzparser.c (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/misc/tzparser.c?rev=1.1&content-type=text/x-cvsweb-markup)
pgsql/src/include/utils:
tzparser.h (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/tzparser.h?rev=1.1&content-type=text/x-cvsweb-markup)
pgsql/src/timezone/tznames:
Africa.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Africa.txt?rev=1.1&content-type=text/x-cvsweb-markup)
America.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/America.txt?rev=1.1&content-type=text/x-cvsweb-markup)
Antarctica.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Antarctica.txt?rev=1.1&content-type=text/x-cvsweb-markup)
Asia.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Asia.txt?rev=1.1&content-type=text/x-cvsweb-markup)
Atlantic.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Atlantic.txt?rev=1.1&content-type=text/x-cvsweb-markup)
Australia (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Australia?rev=1.1&content-type=text/x-cvsweb-markup)
Australia.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Australia.txt?rev=1.1&content-type=text/x-cvsweb-markup)
Default (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Default?rev=1.1&content-type=text/x-cvsweb-markup)
Etc.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Etc.txt?rev=1.1&content-type=text/x-cvsweb-markup)
Europe.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Europe.txt?rev=1.1&content-type=text/x-cvsweb-markup)
India (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/India?rev=1.1&content-type=text/x-cvsweb-markup)
Indian.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Indian.txt?rev=1.1&content-type=text/x-cvsweb-markup)
Makefile (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Makefile?rev=1.1&content-type=text/x-cvsweb-markup)
Pacific.txt (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/Pacific.txt?rev=1.1&content-type=text/x-cvsweb-markup)
README (r1.1)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/tznames/README?rev=1.1&content-type=text/x-cvsweb-markup)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2006-07-25 04:11:25 pgsql: Done: > o -Allow customization of the known set of TZ names
Previous Message Andrew Dunstan 2006-07-25 01:37:42 pgsql: Use correct ifdef test for cygwin, namely __CYGWIN__ (note

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2006-07-25 03:54:48 Re: On-disk bitmap index patch
Previous Message Alvaro Herrera 2006-07-25 03:46:58 Re: pgstattuple extension for indexes