Possible documentation error on pg_catalog.pg_timezone_abbrevs

From: joan(at)sanchezsabe(dot)com
To: pgsql-docs(at)postgresql(dot)org
Subject: Possible documentation error on pg_catalog.pg_timezone_abbrevs
Date: 2017-08-02 22:03:28
Message-ID: 20170802220328.8429.72687@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/view-pg-timezone-names.html
Description:

With regard to documentation page:

https://www.postgresql.org/docs/current/static/view-pg-timezone-names.html

Testing:

SELECT name, abbrev, utc_offset, is_dst FROM pg_catalog.pg_timezone_abbrevs
;

... produces the error

ERROR: column "name" does not exist
LINE 1: SELECT name, abbrev, utc_offset, is_dst FROM pg_timezone_abb...

Apparently, the column "name" isn't there any more.

SELECT * FROM pg_catalog.pg_timezone_abbrevs LIMIT 1;

produces

abbrev | utc_offset | is_dst
:----- | :--------- | :-----
ACDT | 10:30:00 | t

Either the table (or view) is lacking a column, or the documentation is
wrong.

Tested on PostgreSQL 9.6.2 at
http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=9f367fa77616ddf9af721091366bd792

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Thom Brown 2017-08-02 23:37:20 Re: Possible documentation error on pg_catalog.pg_timezone_abbrevs
Previous Message Tom Lane 2017-08-02 20:28:46 Re: Client interface for Tcl