[DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs

Поиск
Список
Период
Сортировка
От joan@sanchezsabe.com
Тема [DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs
Дата
Msg-id 20170802220328.8429.72687@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: [DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs  (Thom Brown <thom@linux.com>)
Список 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


В списке pgsql-docs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [DOCS] Client interface for Tcl
Следующее
От: Thom Brown
Дата:
Сообщение: Re: [DOCS] Possible documentation error on pg_catalog.pg_timezone_abbrevs