Re: doc: cosmetic changes in index items

2020-11-24 Thread Fujii Masao




On 2020/11/22 6:32, Euler Taveira wrote:

On Mon, 16 Nov 2020 at 12:26, Fujii Masao mailto:masao.fu...@oss.nttdata.com>> wrote:


I found that only the following three index items have " ,"
(i.e., space + comma) in the docs. This is not harmful and
is very minor issue, but I'd like to get rid of that unnecessary
space character for the sake of consistency. Thought?

Good catch. +1.


Pushed. Thanks!

Regards,

--
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION




Missing time zone data

2020-11-24 Thread PG Doc comments form
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.


Re: Missing time zone data

2020-11-24 Thread Tom Lane
PG Doc comments form  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




Functions should be Functions & Procedures

2020-11-24 Thread PG Doc comments form
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/plpgsql-overview.html
Description:

Hi,

since PostgreSQL 11 we have procedures, so referencing to only functions
here seems to ignore that. Shouldn't procedures be mentioned here as well?

Regards
Daniel