Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-committerspgsql-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

pgsql-hackers by date

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

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group