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
Date: Tue, 24 Nov 2020 12:35:18 -0500
Message-ID: <290841.1606239318@sss.pgh.pa.us> (raw)
In-Reply-To: <160623543810.25814.6968499611094905921@wrigleys.postgresql.org>
References: <160623543810.25814.6968499611094905921@wrigleys.postgresql.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, bhgbae+postgresqlorg@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: Missing time zone data
In-Reply-To: <290841.1606239318@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox