From f1e5812906aa94f8a595e14a2577228b86db4d78 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Sat, 16 Feb 2008 21:51:04 +0000 Subject: [PATCH] Update docs to reflect the fact that we can now deal with DST rules outside the 32-bit-time_t range. Also, refer to Olson's tz database as the 'zoneinfo' database, a name that upstream sometimes uses, not 'zic database' which they never use. --- doc/src/sgml/datatype.sgml | 14 +++++++------- doc/src/sgml/datetime.sgml | 2 +- doc/src/sgml/installation.sgml | 2 +- 3 files changed, 9 insertions(+), 9 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 5887d97b4a..e863aef555 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -2187,11 +2187,11 @@ January 8 04:05:06 1999 PST world became somewhat standardized during the 1900's, but continue to be prone to arbitrary changes, particularly with respect to daylight-savings rules. - PostgreSQL currently supports daylight-savings - rules over the time period 1902 through 2038 (corresponding to the full - range of conventional Unix system time). Times outside that range are - taken to be in standard time for the selected time zone, no - matter what part of the year they fall in. + PostgreSQL uses the widely-used + zoneinfo time zone database for information about + historical time zone rules. For times in the future, the assumption + is that the latest known rules for a given time zone will + continue to be observed indefinitely far into the future. @@ -2254,7 +2254,7 @@ January 8 04:05:06 1999 PST pg_timezone_names view (see ). PostgreSQL uses the widely-used - zic time zone data for this purpose, so the same + zoneinfo time zone data for this purpose, so the same names are also recognized by much other software. @@ -2287,7 +2287,7 @@ January 8 04:05:06 1999 PST be functionally equivalent to USA East Coast time. When a daylight-savings zone name is present, it is assumed to be used according to the same daylight-savings transition rules used in the - zic time zone database's posixrules entry. + zoneinfo time zone database's posixrules entry. In a standard PostgreSQL installation, posixrules is the same as US/Eastern, so that POSIX-style time zone specifications follow USA daylight-savings diff --git a/doc/src/sgml/datetime.sgml b/doc/src/sgml/datetime.sgml index fade3400a9..2caf39a27d 100644 --- a/doc/src/sgml/datetime.sgml +++ b/doc/src/sgml/datetime.sgml @@ -430,7 +430,7 @@ For reference purposes, a standard installation also contains files Africa.txt, America.txt, etc, containing information about every time zone abbreviation known to be in use - according to the zic timezone database. The zone name + according to the zoneinfo timezone database. The zone name definitions found in these files can be copied and pasted into a custom configuration file as needed. Note that these files cannot be directly referenced as timezone_abbreviations settings, because of diff --git a/doc/src/sgml/installation.sgml b/doc/src/sgml/installation.sgml index 0c2f526faa..4d306d9dae 100644 --- a/doc/src/sgml/installation.sgml +++ b/doc/src/sgml/installation.sgml @@ -1032,7 +1032,7 @@ su - postgres PostgreSQL includes its own time zone database, which it requires for date and time operations. This time zone - database is in fact compatible with the zic time zone + database is in fact compatible with the zoneinfo time zone database provided by many operating systems such as FreeBSD, Linux, and Solaris, so it would be redundant to install it again. When this option is used, the system-supplied time zone database -- 2.39.5