[DOCS] misleading ALTER TABLE SET STORAGE

2016-11-09 Thread vodevsh
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/storage-toast.html Description: Hi, Was reading https://www.postgresql.org/docs/current/static/storage-toast.html and the bit with "...table column can be altered with ALTER TABLE

[DOCS] jsonb_each_text(jsonb) returns value::jsonb, not text

2016-12-09 Thread vodevsh
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/functions-json.html Description: Hi, According to https://www.postgresql.org/docs/current/static/functions-json.html, "jsonb_each_text(jsonb)" returns "setof key text, value text"

[DOCS] pg_class.reloptions for tables to mention Storage Parameters

2016-12-21 Thread vodevsh
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.3/static/catalog-pg-class.html Description: Hi, at https://www.postgresql.org/docs/9.3/static/catalog-pg-class.html the "reloptions" column description is "Access-method-specific options,

[DOCS] user mapping options list

2017-03-22 Thread vodevsh
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/sql-createusermapping.html Description: Hi, Could you please also give the full list of options or at least link to on the page? Same favour to ask on "create server" command page.

[DOCS] suggestion to make an example easier reproducible

2017-05-04 Thread vodevsh
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/plpgsql-implementation.html Description: Documentation is good. But if you change `INSERT INTO logtable VALUES (logtxt, 'now');` to `RAISE INFO '%','now'::timestamptz;` in example

[DOCS] ALTER SYSTEM is equal to editing postgresql.auto.conf, not postgres.conf

2017-07-13 Thread vodevsh
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/config-setting.html Description: > The already-mentioned ALTER SYSTEM command provides a SQL-accessible means of changing global defaults; it is functionally equivalent to editing

[DOCS] tip to workaround trailing spaces removal on char to varchar conversion

2017-09-20 Thread vodevsh
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/datatype-character.html Description: removing trailing spaces on (implicit) cast from char to text can be painful, and always surprising as shown in example with SELECT 'a '::CHAR