From: Tom Lane <tgl@sss.pgh.pa.us>
To: bhgbae+postgresqlorg@gmail.com
cc: pgsql-docs@lists.postgresql.org
Subject: Re: Missing time zone data
In-reply-to: <160623543810.25814.6968499611094905921@wrigleys.postgresql.org>
References: <160623543810.25814.6968499611094905921@wrigleys.postgresql.org>
Comments: In-reply-to PG Doc comments form <noreply@postgresql.org>
	message dated "Tue, 24 Nov 2020 16:30:38 +0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <290840.1606239318.1@sss.pgh.pa.us>
Date: Tue, 24 Nov 2020 12:35:18 -0500
Message-ID: <290841.1606239318@sss.pgh.pa.us>
Precedence: bulk

PG Doc comments form <noreply@postgresql.org> writes:
> pg_timezone_names supposedly has the list of full time zone names (e.g.,
> US/Eastern) used in Postgresql, but all it has is the list of columns for
> the list. The list itself appears to be missing.

Hm, works for me:

regression=# select * from pg_timezone_names;
                  name                  | abbrev | utc_offset | is_dst 
----------------------------------------+--------+------------+--------
 Africa/Accra                           | GMT    | 00:00:00   | f
 Africa/Algiers                         | CET    | 01:00:00   | f
 Africa/Bissau                          | GMT    | 00:00:00   | f
 Africa/Casablanca                      | +01    | 01:00:00   | t
 ... etc etc ...
 W-SU                                   | MSK    | 03:00:00   | f
 Poland                                 | CET    | 01:00:00   | f
 Kwajalein                              | +12    | 12:00:00   | f
 NZ-CHAT                                | +1345  | 13:45:00   | t
(1187 rows)

My guess is you've got an installation problem that prevents PG
from finding the tzdb file tree.  But it's hard to debug that
on the strength of no information about the server configuration.
In any case, I don't think this is a documentation issue ...

			regards, tom lane