pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedMissing time zone data
2+ messages / 2 participants
[nested] [flat]
* Missing time zone data
@ 2020-11-24 16:30 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Doc comments form @ 2020-11-24 16:30 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: bhgbae+postgresqlorg@gmail.com
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/view-pg-timezone-names.html
Description:
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Missing time zone data
@ 2020-11-24 17:35 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2020-11-24 17:35 UTC (permalink / raw)
To: bhgbae+postgresqlorg@gmail.com; +Cc: pgsql-docs@lists.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-11-24 17:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-24 16:30 Missing time zone data PG Doc comments form <noreply@postgresql.org>
2020-11-24 17:35 ` Tom Lane <tgl@sss.pgh.pa.us>
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