pl/pgsql errors when multi-dimensional arrays are used

2021-04-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/arrays.html Description: I have PostgreSQL 13. Let's declare the type below, then use it in pl/pgsql: create type typ1 as ( fld1 int[][] ); do $$ declare a typ

Wrong type for the left argument of the operator "|/" and "||/" in chapter 9.3

2021-04-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-math.html Description: The left argument of the operator square root |/ and cube root ||/ in the current documentation is double precision. But to my experience that should also

Clarify how triggers relate to transactions

2021-04-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtrigger.html Description: https://www.postgresql.org/docs/current/sql-createtrigger.html mentions the word "transaction" only once, in reference specifically to constraint trigge

"68.4. Visibility Map" change suggestion.

2021-04-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/storage-vm.html Description: Currently the documentation lists the line below; `Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are kno

Alter sequence restart parameter type

2021-04-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-altersequence.html Description: Hi! I have some question about alter sequence. I can see in your documentation https://www.postgresql.org/docs/12/sql-altersequence.html Synopsis: ALTE

Make link to different section

2021-04-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/queries-table-expressions.html Description: Hi. It would be nice to make reference [here](https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-LATERAL) to section

Chapter 30. Logical Replication slightly unclear

2021-04-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/logical-replication.html Description: I think the below snippet from https://www.postgresql.org/docs/12/logical-replication.html reads pretty clear for a native English speaker, but I have

regarding stored procedure

2021-04-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createprocedure.html Description: This documentation is missing the part on the topic whether we can insert data in temporary table from Stored procedure output.

Rounding strategy

2021-04-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-math.html Description: The 'round' mathematical function documentation doesn't specify its rounding strategy. If this would be documented then users can rely on its rounding beha

Typo in DATATYPE-JSONPATH

2021-04-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-json.html Description: Hello, On the DATATYPE-JSONPATH page: https://www.postgresql.org/docs/13/datatype-json.html#DATATYPE-JSONPATH There is a line that shows that GIN indexes

Date/Time Functions and Operators

2021-04-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-datetime.html Description: Please also include some examples that extract few columns from some tables. For e.g. SELECT EXTRACT(YEAR FROM hire_date) FROM Employee WHERE id = 1234

Incorrect in Window Functions

2021-04-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-window.html Description: Link: https://www.postgresql.org/docs/12/tutorial-window.html > The first three output columns come directly from the table empsalary, and there is one o

Typo in psql doc

2021-04-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/app-psql.html Description: There is a spurious space inside the documentation: \set HISTFILE ~/.psql_history- :DBNAME instead of \set HISTFILE ~/.psql_history-:DBNAME

SELECT last_value FROM sequence_name;

2021-04-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-sequence.html Description: Please add Note, how to get the (global) last value: SELECT last_value FROM sequence_name; https://dba.stackexchange.com/questions/3281/how-do-i-use-cu

repeated info in sections 4.1.1, 4.1.2.3

2021-04-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-syntax-lexical.html Description: Simply want to tell you that there is repeated almost word-in-word info in 4.1.1 (starting with "A variant of quoted identifiers allows including", end

PL/Tcl - examples not working

2021-04-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/pltcl-trigger.html Description: Example on this page is not working https://www.postgresql.org/docs/13/pltcl-trigger.html Gives ERROR: bind message supplies 1 parameters, but prepared sta

mingw.org fails to load anything of value

2021-04-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/installation-platform-notes.html Description: 16.7.4. MinGW/Native Windows refers to the site http://www.mingw.org which for me loads a blank page

How to access SQL commands

2021-03-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/database-roles.html Description: If you have no experience using SQL, you don't know how to access Postgres SQL functions Crucially, I need to know about: sudo su - postgres I didn't at t

Logical replication restart position (restart_lsn)

2021-03-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/warm-standby.html Description: Hi, I was struggling to understand why my logical replication clients (using the wal2json plugin) are not advancing the restart_lsn as much as I expected. E.

ssl connection with certificate

2021-03-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/index.html Description: Good morning. Following the instructions https://www.postgresql.org/docs/11/ssl-tcp.html I can't establish a local connection with certificate. In the pg_hba.conf

Wrong distance shown in miles for extension earthdistance

2021-03-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/earthdistance.html Description: Hi, I have installed CREATE EXTENSION CUBE; CREATE EXTENSION earthdistance; Post which I ran the following query: SELECT (POINT (19.974, 72.756)<@> POINT

"there is no way to insert less than one row"

2021-03-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/dml-insert.html Description: The documentation here says the following: "Of course you can also insert more than one row, but there is no way to insert less than one row." I tried this in

A very confusing line...

2021-03-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/role-membership.html Description: I guess the phrase because joe “inherits” admin's privileges should be changed to because joe was granted admin's privileges. The point is, otherwise h

Duplicate "SELECT current_user;"

2021-03-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-rowsecurity.html Description: On this page I see the following example: cut => SELECT current_user; current_user -- admin (1 row) => select inet_client_addr();

How are UUIDs sorted / compared ?

2021-03-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-uuid.html Description: I'm missing information about what really sets the UUID datatype apart? For example I'm missing information as to how the UUID is sorted, i.e. how two UUID

Missing mention of autovacuum_work_mem

2021-03-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/progress-reporting.html Description: The "vacuuming indexes" documentation has: "If a table has any indexes, this will happen at least once per vacuum, after the heap has been completely

advanced.sql tutorial script

2021-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-advanced-intro.html Description: I built tutorial files according to instructions from the section 2.1. And I found that the script advanced.sql covers only the section "3.6. Inhe

INNER JOIN syntax is not commonly used?

2021-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-join.html Description: This page shows a WHERE syntax to join tables. After that it shows an example of the INNER JOIN syntax: SELECT * FROM weather INNER JOIN cities ON (wea

make tutorial 13.2

2021-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-sql-intro.html Description: https://www.postgresql.org/docs/13/tutorial-sql-intro.html This page tells how to make tutorial files: $ cd .../src/tutorial $ make I have a binary di

Jumbled words

2021-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createrole.html Description: "modified by later ALTER ROLE" to be changed to "modified later by ALTER ROLE".

Step 8 does not perform as documented

2021-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/continuous-archiving.html Description: Under the steps of Recovering with continuous logging, Step 8 says: "Start the server. The server will go into recovery mode and proceed to read thro

missing schema_name

2021-03-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createschema.html Description: The second and forth syntax for CREATE SCHEMA is missing schema_name.

set auto commit is not working

2021-02-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ecpg-sql-set-autocommit.html Description: I tested with " PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit" The result is below. pos

pgbench: supports PGDATABASE / warning about -d

2021-02-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/legalnotice.html Description: 1) pgbench has always supported the PGDATABASE env variable, but it is not listed along PGHOST/PGPORT & PGUSER in https://www.postgresql.org/docs/13/pgbench

incoorect restore_command

2021-02-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/continuous-archiving.html Description: Hi everyone, I've been trying out saving and restoring compressed archive logs. The restore_command stated in the docs at "25.3.6.2. Compressed Arch

Transaction ID modulo

2021-02-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/routine-vacuuming.html Description: Hello, transaction ID modulo is not correct. The sentence "Normal XIDs are compared using modulo-2^32 arithmetic" should be "Normal XIDs are compared

createdb

2021-02-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-createdb.html Description: In the getting started documentation, it will have been better to start with how to 'login to postgres' and cover the idea of 'roles'. Or if previously

Inaccuracy in wal_receiver_status_interval parameter description

2021-02-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-replication.html Description: The documentation says that setting wal_receiver_status_interval to 0 disable updates of replication status completely. However walreceiver kee

About the return states of SPI_execute for plpy.execute().status()

2021-02-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/spi-spi-execute.html Description: Hello. I'm using Postgres 9.3.25. I know it's an unsupported version but the documentation pages that I will mention stay the same between 9.3 and 13. In

Matview Refresh Privilege Clarification

2021-02-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-refreshmaterializedview.html Description: I hope everyone is well. I have not found it explicitly specify anywhere but from my experience I have gathered that when you refresh a mater

Duplicate documentation within the same page

2021-02-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-syntax-lexical.html Description: Hello, in the bottom part of https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS there is an explation about escaped

Documentation on Hash and btree Indexes on jsonb

2021-02-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-json.html Description: Hello everyone, we are planning to test postgres as a nosql database for streaming kafka events (converted to jsonb) into it next week. Therefore I am res

pgstattuple() should not be used on hash indexes

2021-02-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/pgstattuple.html Description: pgstattuple works on some non-table relations, such as indexes. However it does not work reliably on hash indexes. It works on some, but on others it reports

Small correction in chown command to set the owner of the pgsql data dir correctly

2021-02-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/creating-cluster.html Description: "root# mkdir /usr/local/pgsql root# chown postgres /usr/local/pgsql root# su postgres postgres$ initdb -D /usr/local/pgsql/data" If these steps are follo

The synopsis of "ALTER DEFAULT PRIVILEGES" statement is too difficult to understand

2021-02-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-alterdefaultprivileges.html Description: The syntax/synopsis of the "ALTER DEFAULT PRIVILEGES" statement on the https://www.postgresql.org/docs/13/sql-alterdefaultprivileges.html page

Unnecessary use of .* in examples

2021-02-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-matching.html Description: In the table for the ~ (and friends) operator, every example has a pointless set of '.*' surrounding the text to be matched. These unnecessary operator

is_local parameter on set_config function

2021-01-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/config-setting.html Description: Hello, I have just used the set_config(...) function for the first time and it took me a bit of experimenting to understand the effect of the is_local pa

Postgres upgrade does not mention requirement to have only 1 user

2021-01-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/pgupgrade.html Description: During the pg_upgrade process, a check is run to make sure pg_catalog.pg_roles has only a single non pg_* user, typically this is just 'postgres'. If this check

TRUNCATE VIEW

2021-01-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-priv.html Description: Dear Team, In this link https://www.postgresql.org/docs/12/ddl-priv.html you mentioned like Truncate of view, Is it possible? TRUNCATE Allows TRUNCATE on a tab

Windows Powershell

2021-01-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/app-pgdump.html Description: To dump a database into a custom-format archive file: $ pg_dump -Fc mydb > db.dump There should be a warning here stating that (or similar): Windows Powershel

the doc should mention one particular aspect of partial indexes

2021-01-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-vacuum.html Description: Hi, I think the documentation should mention one particular aspect of b-tree partial indexes: Say we have a row that satisfy a partial index's predicate. Tha

Temporary table semantics

2021-01-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtable.html Description: The explanation of the behaviour of temporary tables could be clearer. In particular, there is no statement that categorically says that rows in the tempo

i.e. and e.g. used with incorrect meaning

2021-01-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ssh-tunnels.html Description: You're gonna hate this -- a grammar nit pick. But for the few of us who know what e.g. and i.e. mean, the wrong one is confusing. e.g. = exempli gratia = for

Truncate View

2021-01-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-trigger.html Description: http://bit.ly/1w5ISeU This states that all ON triggers are at the row level I am trying to find details on how ON TRUNCATE will work for a view. I underst

pg_dump no-owner option

2021-01-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/app-pgdump.html Description: Currently the documentation reads: This option is only meaningful for the plain-text format. This statement is imprecise. Actually the cownership has nothin

Typo

2021-01-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-string.html Description: Hi, *Really* tiny issue, but the two the functions listed here have unbalanced parenthesis. (Obviously this is super low priority.) Best, Mike

scram-sha-256 authentication

2021-01-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/auth-password.html Description: How do you encode a plain password to the corresponding SCRAM-SHA-256 encryption? Using online tools I obtain a result in a different format the in e.g. the

.pgdump file extension

2021-01-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/app-pgdump.html Description: Please consider entering a suggested name extension for pg_dump files in custom format. For example ".pgdump". Nobody would have any doubts that this is a data

Potential typo in abbreviated insertion query

2020-12-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/executor.html Description: It's located within the parentheses of the last paragraph. >(A simple INSERT ... VALUES command creates a trivial plan tree consisting of a single Result node,

Trusted versus untrusted Pl language

2020-12-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpython.html Description: Hey all: This page & the PL/PERL page are the closest I have seen in the docs about trusted versus untrusted languages. It would be great if we could add a sub

Typo for cd commands

2020-12-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-sql-intro.html Description: I believe that the following two commands in the page "https://www.postgresql.org/docs/13/tutorial-sql-intro.html"; should have a slash in the middle o

SELECT ... FOR UPDATE OF

2020-12-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-select.html Description: The FOR UPDATE clause of the SELECT statement can be followed by an OF clause, but this is never explained at all in the documentation, as far as I can tell. W

https://www.postgresql.org/docs/12/logical-replication-restrictions.html

2020-12-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/logical-replication-restrictions.html Description: Here, we should add one more point: * Any column part of the replica identity needs to be of a type with a equality operator. Use Case:

Wrong configuration of tcp_user_timeout can terribly affects tcp_keepalives mechanism

2020-12-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/bug-reporting.html Description: These changes are applicable for PostgreSQL 12 and later versions. It is necessary to add a Note to tcp_user_timeout configuration parameter with following

pg_upgrade is not correct

2020-12-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/pgupgrade.html Description: If we use the following command to upgrade the standby server, then new cluster will create by old_cluster which is not correct. rsync --archive --delete --hard

Mention invalid null byte sequence

2020-12-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-character.html Description: I discovered accidentally that PostgreSQL doesn't accept null byte in text type. It seems that Oracle does (see https://www.postgresql.org/message-id/d

Tutorial: Inheritance

2020-12-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-inheritance.html Description: Hi, I think the text on this page should start with a hint that inheritance is something special. Or maybe ... does it make sense that this is in t

Hyperlink to src/tutorial/ would be nice (SQL Tutorial)

2020-12-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-sql-intro.html Description: Hi, On this page https://www.postgresql.org/docs/13/tutorial-sql-intro.html `src/tutorial/` gets mentioned. It would be very kind if this could be a

TOAST pointer size

2020-12-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/storage-toast.html Description: Hey team, It would be nice to add a break-down of why the TOAST Pointer size is 18 bytes quoting here ```A pointer datum representing an out-of-line on

link may be broken

2020-12-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/index.html Description: Hello, the following page: https://www.postgresql.org/about/featurematrix/detail/340/ contains a link to "VACUUM documentation": https://www.postgresql.org/doc

maybe ignore my previous comment

2020-12-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-statements.html Description: So I do see that they are anchors for each section at the top of the page. I could have sworn that for some doc pages there was also an anchor symbol

The sub-categories do not have anchors on this page

2020-12-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-statements.html Description: Hey Kind Doc People I was hoping we could add sub-anchors for each of the sections on this page. It would make it easier to link to the specific conten

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?

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

timed messages

2020-11-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-errors-and-messages.html Description: Please add an example how to format messages, that they will contain timestamp. Ideally through global/session configuration format for raise

42.6.8 trapping errors

2020-11-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html Description: Hi I think that section should have more examples with the most common errors, like for example no_data_found when doing a select.

create table with a CTE

2020-11-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtableas.html Description: Hi. I think you should include an example on how to create a table from a query that uses a CTE in the query.

tables have merged columns

2020-11-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-json.html Description: In this version i cannot see columns https://www.postgresql.org/docs/13/functions-json.html in older versions are columns seen correctly https://www.postg

Documentation of return values of range functions lower and upper

2020-11-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-range.html Description: Table 9.54 in page https://www.postgresql.org/docs/current/functions-range.html states that the functions lower and upper return NULL if the requested bou

One more example of generating time series

2020-11-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-srf.html Description: I find this kind of query very useful: If you don't know the end date, but you know how many time steps to add, you can use a query like this select now()+

'pg_global' cannot be used as default_tablespace.

2020-11-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/bug-reporting.html Description: Tablespace 'pg_global' is one of the two auto-generated tablespace by initdb, and 'pg_global' should not be used as the default_tablespace, since it is used

Tips about using mount point directly as the data_directory.

2020-11-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/bug-reporting.html Description: Using a mount point directly as the data_directory is not recommended, but this tip is not recorded in the doc https://www.postgresql.org/docs/11/runtime-co

The relationship between 'min_wal_size', 'max_wal_size' and 'wal_segment_size' is not record.

2020-11-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/bug-reporting.html Description: configuration option 'min_wal_size' and 'max_wal_size' must be at least twice 'wal_segment_size', but none of these information was mentioned in the descrip

Addition to content

2020-11-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-conditional.html Description: Hello I would be helpful to add that NULLIF and COALESCE need to be of same data type. Thank you

Make it clear that the default values are already set/available when triggers are being evaluated

2020-11-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-default.html Description: I wanted to know whether the default values are already set when a BEFORE INSERT trigger is being evaluated, I couldn't find it in the documentation. I bet it

Possible Example Error in Documentation

2020-11-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html Description: We are using Postgres 12. When I use the example given for transaction_test1() from the documentation here: https://www.postgresql.org/account/commen

On what system does the postgresql docs run?

2020-11-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/libpq-pgpass.html Description: Hi, I really like the postgresql documentation system and am curious what it is. After viewing source and digging around, I can't seem to determine what it'

127.0.0.1 or localhost

2020-10-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/libpq-pgpass.html Description: Hi All, It's not actually a problem, it's a question. pgpass in my case, has two lines, one with 127.0.0.1 and another with localhost what would be the d

COPY statement: no list of the allowed values for "format_name"

2020-10-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-copy.html Description: Look at the account of the COPY statement, here: https://www.postgresql.org/docs/11/sql-copy.html and see this: « [ [ WITH ] ( option [, ...] ) ] » It goes o

What does "[backends] should seldom or never need to wait for a write to occur" mean?

2020-10-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/runtime-config-resource.html Description: https://www.postgresql.org/docs/13/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER says: "There is a separate server proc

Missing directory is mentioned on page https://www.postgresql.org/docs/13/libpq-exec.html.

2020-10-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/libpq-threading.html Description: On page https://www.postgresql.org/docs/13/libpq-exec.html, non-existing directory is mentioned: src/tools/thread.

Missing file is mentioned on page https://www.postgresql.org/docs/13/libpq-exec.html

2020-10-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/libpq-exec.html Description: On page https://www.postgresql.org/docs/13/libpq-exec.html, non-existing file is mentioned: src/include/catalog/pg_type_d.h. We fail to find it in this catalog

physical should be logical

2020-10-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/logical-replication-publication.html Description: Hi, On this page, https://www.postgresql.org/docs/12/logical-replication-publication.html The first line states: A publication can be

Chapter 14.1.1, small typo on costs?

2020-10-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/using-explain.html Description: I am reading 14.1.1 and at the very end (just before 14.1.2) I see: "which shows that the planner thinks that sorting onek by index-scanning is about 12% m

exceptions

2020-10-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/errcodes-appendix.html Description: 02000 no_data should read no_data_found

Needs a link to docuementation about the server log location/configuration

2020-10-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/client-authentication-problems.html Description: The article on authentication problems refers to "the log" and the "server log" but lacks information on where to find that log or how to c

Word fix

2020-10-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html Description: Search for the word indeed found here https://www.postgresql.org/docs/13/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING-PROCEDURE

Please add best practice concerning user accounts

2020-10-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/postgres-user.html Description: The page describes the postgres user typically used as superuser for a PostgreSQL cluster. It would be useful to add information about best practices concer

https://www.postgresql.org/docs/current/functions-sequence.html

2020-10-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-sequence.html Description: This page: https://www.postgresql.org/docs/current/functions-sequence.html doesn't seem to mention that there's a way to get the "cross session" curren

https://www.postgresql.org/docs/13/tutorial-join.html missing a table

2020-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-join.html Description: This page references a "cities" table, but not prior page showed this table. Suggest adding a new "cities" table on this page.

<    1   2   3   4   5   6   7   8   9   10   >