From 2874d38d7f705ab9a8679018253f3d8a59d0460f 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 | 16 ++++++++-------- doc/src/sgml/datetime.sgml | 4 ++-- doc/src/sgml/installation.sgml | 4 ++-- 3 files changed, 12 insertions(+), 12 deletions(-) diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index 8b57b0ea78..f36ec178d8 100644 --- a/doc/src/sgml/datatype.sgml +++ b/doc/src/sgml/datatype.sgml @@ -1,4 +1,4 @@ - + Data Types @@ -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 73e846e54d..df715144db 100644 --- a/doc/src/sgml/datetime.sgml +++ b/doc/src/sgml/datetime.sgml @@ -1,4 +1,4 @@ - + Date/Time Support @@ -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 6b15ffb7b2..72f7960bf8 100644 --- a/doc/src/sgml/installation.sgml +++ b/doc/src/sgml/installation.sgml @@ -1,4 +1,4 @@ - + <![%standalone-include[<productname>PostgreSQL</>]]> @@ -1032,7 +1032,7 @@ su - postgres <para> <productname>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 <quote>zic</> time zone + database is in fact compatible with the <quote>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.40.0