Count parameter for cursor_to_xml

2024-09-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-xml.html Description: cursor_to_xml ( cursor refcursor, count integer, nulls boolean, tableforest boolean, targetns text ) → xml There is not explanation what th

[Issue] Getting started not oppening.

2024-09-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-start.html Description: This section in the documentation not opening. https://www.postgresql.org/docs/14/tutorial-start.html

The option was not described: connection-option

2024-09-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pgdump.html Description: Hi. The option `connection-option` is mentioned but is not described. Please describe it. Thanks.

I use the example in this page ,but got error

2024-09-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/xfunc-c.html Description: quhan@khan1-3 build % clang -shared -fPIC -o libpqtxt.dylib ../src/*.c -I/Library/PostgreSQL/17/include/postgresql/server -I/Library/PostgreSQL/17/include -L/Libr

No details on how to use Hash partitions: no example, no syntax

2024-09-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ddl-partitioning.html Description: I would like the documentation to explain how to use Hash partitions. It says one needs to provide a modulus and remainder, but the exact syntax is not s

Add mention to related system catalog functions on Tablespaces documentation pages.

2024-09-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/manage-ag-tablespaces.html Description: The tablespaces documentation page seems to be missing a mention to the following functions: pg_tablespace_databases pg_tablespace_location These a

Elaborate on phrase "table metadata" in the Notes section of ALTER by specifying pg_attribute

2024-09-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-altertable.html Description: I am newish to Postgres, and the term "table metadata" was confusing to me. I am more than happy to submit a patch for this. I'm just unfamiliar with the

Mathematical Functions and Operators

2024-09-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-math.html Description: Typically, exponentiation (which is represented here by ^) is a right-associative operation. This means that the expression 2 ^ 3 ^ 3 should be interpreted

pg_upgrade -c cannot be run if old cluster is running

2024-09-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/pgupgrade.html Description: https://www.postgresql.org/docs/15/pgupgrade.html tells "You can use pg_upgrade --check to perform only the checks, even if the old server is still running." I

retrieving results of procedures with OUT params

2024-09-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/libpq-exec.html Description: https://www.postgresql.org/docs/16/libpq-exec.html#LIBPQ-PQRESULTSTATUS Existing text: If the result status is PGRES_TUPLES_OK, PGRES_SINGLE_TUPLE, or PGRES_TU

intarray extension installation

2024-08-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/intarray.html Description: Hi, can you please specify somewhere that intarray extension is part of contrib package? I found this out only on a stackoverflow from almost 10 years ago. Than

May be not exclusive locks, but access exclusive locks?

2024-08-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pgdump.html Description: Cite Requesting exclusive locks on database objects while running a parallel dump could cause the dump to fail. End cite As far as I can understand the problem

Query in CTAS accepts optional parentheses not documented

2024-08-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-createtableas.html Description: The compatibility section describes our deviation from the standard regarding making optional the surrounding of the “query” in parentheses, but nowhere

Examples Missing

2024-08-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pgdump.html Description: Examples should be added for every option available for pg_dump. I was looking for example for on-conflict-do-nothing, and rows-per-insert and what does nrows

Incorrect option name for meson build

2024-08-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/catalog-pg-type.html Description: Page: https://www.postgresql.org/docs/16/install-meson.html#CONFIGURE-AUTO-FEATURES-MESON Description: Hello! As indicated in the "Build Process Details"

Typo on 2.3. PostgreSQL

2024-08-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/history.html Description: In https://www.postgresql.org/docs/16/history.html#HISTORY-POSTGRESQL, Chapter 2.3. PostgreSQL is written in first sentence: "By 1996, it became clear that the na

constraint_exclusion not working correctly

2024-08-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ddl-partitioning.html Description: Hello, I have noted that, in order for constraint exclusion to work correctly when partitioning using inheritance, we must use simple comparisons in che

Documentation of .pgpass for Unix is incomplete

2024-08-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/libpq-pgpass.html Description: The documentation of the .pgpass password file is incomplete in the Unix case (https://www.postgresql.org/docs/16/libpq-pgpass.html): It does not mention ho

Managing SSL Connections

2024-08-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ssl-tcp.html Description: It would be handy to see documentation on the process of renewing a certificate in terms of the impact it would have if you force clients to do TLS connections. F

Tutorial clarify

2024-08-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-install.html Description: New and wanted to follow getting started docs but it seems it was written for Unix. Would be nice if you built out the getting started docs for more than

There is an invalid value for cidr type in the "Table 8.22. cidr Type Input Examples"

2024-08-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-net-types.html Description: On the page: https://www.postgresql.org/docs/16/datatype-net-types.html#DATATYPE-CIDR in the "Table 8.22. cidr Type Input Examples" is invalid value f

incorrect PostgreSQL documentation for pg_type

2024-08-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/catalog-pg-type.html Description: Regarding https://www.postgresql.org/docs/12/catalog-pg-type.html There is an error in the documentation, at least for version 12 (cannot check for versio

add 'from the command line' to tutorial-createdb.html

2024-08-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-createdb.html Description: https://www.postgresql.org/docs/16/tutorial-createdb.html it says ... "To create a new database, in this example named mydb, you use the following

incorrect (incomplete) description for "alter domain"

2024-07-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-alterdomain.html Description: In the Synopsis section of https://www.postgresql.org/docs/current/sql-alterdomain.html this is incorrect (incomplete): "ALTER DOMAIN name ADD domain_cons

INSERT ... RETURNING documentation

2024-07-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-insert.html Description: The grammar [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ] seems wrong to me. I appears to say it could be either RETURNING * or output_exp

Typo in 15.3.4

2024-07-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/parallel-plans.html Description: In section 15.3.4, I believe "multiple results sets" is a typo for "multiple result sets". It says: > Plans that involve appending multiple results sets c

wrong field in example

2024-07-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/queries-table-expressions.html Description: >> In the second query, we could not have written SELECT * FROM test1 GROUP BY x, because there is no single value for the column y that could b

Incorrect grammar in 15.2

2024-07-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/when-can-parallel-query-be-used.html Description: Unless I'm misunderstanding the sentence structure here, I believe the word "a" is missing before "parallel query plan" in the following s

Undocumented optionality of handler_statements

2024-07-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-control-structures.html Description: In https://www.postgresql.org/docs/16/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING handler_statements are documented as optional. Ho

Undocumented := alternative in using option of raise statement

2024-07-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-errors-and-messages.html Description: The using option is documented as follows for all variants of the raise statement: USING option = expression [, ... ] However, since "do $$

Undocumented count in FORWARD/BACKWARD direction of MOVE statement

2024-07-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-cursors.html Description: The documentation shows this example for the MOVE statement: MOVE FORWARD 2 FROM curs4; According to the docs, this should not work. The count is docume

Mismatch for connection key/value pair between documentation and code?

2024-07-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/libpq-connect.html Description: Hi PostgreSQL documentation team, I have a confusion regarding parameters used in documentation vs. that in the code. Please clarify if I misunderstand

Change detail text in last example of 43.5.3. Executing a Command with a Single-Row Result

2024-07-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-statements.html Description: The last example in the chapter uses a named parameter "username". As a result, the detail message should use "username" instead of "$1" to match the r

13.2.2. Repeatable Read Isolation Level #

2024-07-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/transaction-iso.html Description: 'UPDATE, DELETE, MERGE, SELECT FOR UPDATE, and SELECT FOR SHARE commands behave the same as SELECT in terms of searching for target rows: they will only f

13.2.1. Read Committed Isolation Level

2024-07-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/transaction-iso.html Description: I don't understend this text. 'INSERT with an ON CONFLICT DO UPDATE clause behaves similarly. In Read Committed mode, each row proposed for insertion wil

Savepoints in plpgsql

2024-07-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-transactions.html Description: https://www.postgresql.org/docs/current/plpgsql-transactions.html In this section nothing mentioned that a savepoint (a subtransaction) will not wor

Chapter "8.8 Geometric Types" of documentation could contain more details

2024-07-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-geometric.html Description: Hi, I am writing to suggest a couple of clarifications to "8.8. Geometric Types" documentation chapter. 1. Documentation does not specify what precisi

tutorial not accurate

2024-07-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-accessdb.html Description: I was able to create a db (mydb) but when I use any of the test SELECT statements, nothing happens. Here is the terminal output when trying your tutoria

8.12. UUID Type

2024-06-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-uuid.html Description: Is this the right sentence? "use of upper-case digits" >>PostgreSQL also accepts the following alternative forms for input: use of upper-case digits

Bibliography reference redirects to a Forbiden page.

2024-06-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/biblio.html Description: "Serializable Snapshot Isolation in PostgreSQL" by D. Ports, in the bibliography leads to a forbidden page. I've managed to find the paper here: https://drkp.net/

CLUSTER details

2024-06-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-cluster.html Description: The cloister command should describe how or deals with free pages (I.e. are released) and what it’s lock model is (i.e. that it is (not yet?) an online operat

Need clarification on "field"

2024-06-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/limits.html Description: Under page "https://www.postgresql.org/docs/current/limits.html";, below limitations are mentioned: field size - 1 GB identifier length - 63 bytes I understand "

I get ERROR: column "table_name" does not exist

2024-06-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-control-structures.html Description: When using GET STACKED DIAGNOSTICS in PL/pgSQL accessing TABLE_NAME, COLUMN_NAME, CONSTRAINT_NAME or SCHEMA_NAME throws an error. The function

Minor accuracy issue

2024-06-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/limits.html Description: Under page "https://www.postgresql.org/docs/current/limits.html";, it is mentioned: relation size - 32TB rows per table - limited by the number of tuples that can

28.4.4. Progress Reporting phase status

2024-05-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/progress-reporting.html Description: Hi there, I noticed that in "28.4.4. Progress Reporting" chapter for `pg_stat_progress_create_index`, the "Table 28.43. CREATE INDEX Phases" may be

The examples given in Chapter 14 are not true.

2024-05-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/performance-tips.html Description: 1) How did you create the `tenk1` table? If you will claim that from the source code of version 9.3, the question arises how CREATE TABLE tenk1 (...) WIT

ltree docs imprecise about sorting order

2024-05-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ltree.html Description: The ltree docs available at https://www.postgresql.org/docs/current/ltree.html state "Comparison sorts in the order of a tree traversal" without specifying the stra

Building from source using clean Ubuntu docker container

2024-05-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/install-make.html Description: Hello there, Below are complete steps for building Postgres from source in a clean docker ubuntu container. Maybe this is useful for your docs? I noticed

Ambiguous description on new columns

2024-05-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/logical-replication-col-lists.html Description: The documentation on this page mentions: "If no column list is specified, any columns added later are automatically replicated." It feels

52.38 pg_proc (postgresql version 14)

2024-05-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/catalog-pg-proc.html Description: I don't know if this is a documentation problem or an error in pg_proc. The document, for the "prokind" column state the following: f for a normal

Fundamental Architecture of PostgreSQL

2024-05-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-arch.html Description: PostgreSQL uses a client/server architecture. As is typical of client/server applications, the client and the server can be on different hosts. In that case

Logical replication - initial data synchronization

2024-05-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/logical-replication-subscription.html Description: I'm reading up on Logical Replication and have been reading the pages in order. The first 2 pages: https://www.postgresql.org/docs/curre

Unclear on Publication documentation page

2024-05-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/logical-replication-publication.html Description: The page in question: https://www.postgresql.org/docs/current/logical-replication-publication.html It says: "If a table without a replic

Explanations not clear

2024-05-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/collation.html Description: I created a collation specifying the ks-level3 setting and with deterministic set to false. But when I compare "a_b" to "a-b" with this collation I get false. A

Connection Info

2024-05-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/server-start.html Description: Hello! On this page: https://www.postgresql.org/docs/14/server-start.html#CLIENT-CONNECTION-PROBLEMS It notes: " A common mistake is to forget to confi

Missing examples for hash partitioning

2024-05-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ddl-partitioning.html Description: There is no example showing the syntax of Hash Partitioning in this section of the documentation, it's missing.

The PostgreSQL Select Syntax

2024-05-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-select.html Description: Dear PostgreSQL Team, I'm writing to seek clarification regarding the scope of the formal syntax outlined in the documentation for the SELECT statement (https

roles that have the CREATEROLE privilege can no longer GRANT predefined roles

2024-05-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/predefined-roles.html Description: roles that have the CREATEROLE privilege can no longer GRANT predefined roles unless they are part of it having the WITH ADMIN option. this needs to be c

No documentation on how pg_ctl is installed

2024-04-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/app-pg-ctl.html Description: I have used postgresql@14 for several years and have always used pg_ctl to start the postgres server, check status etc. I tried upgrading to postgresql@15 wi

Documentation Chapter 16: 8.21

2024-04-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-pseudo.html Description: I tryed to implement a safe_cast function with 2 parameters and a return of type "any" but it failed. I get a syntax error, if I use "any" as a data type,

The prompt is not displayed correctly in the example on psql page

2024-04-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-psql.html Description: On this page https://www.postgresql.org/docs/current/app-psql.html where is? >> `( if there is an unmatched left parenthesis` ```sql testdb=> SELECT t1.first

Postgres_FDW doc doesn't specify TYPE support in Remote Execution Options

2024-04-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/postgres-fdw.html Description: Hi, The https://www.postgresql.org/docs/current/postgres-fdw.html#POSTGRES-FDW-OPTIONS-REMOTE-EXECUTION section mentions for `extensions` configuration optio

Mysteries of the future

2024-04-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-formatting.html Description: I'm not sure that there will be 31 days in 11 months; although postgresql probably knows better what will happen in 2 For example (with the yea

psql option

2024-04-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-psql.html Description: option -X, the specified comma after the letter X https://www.postgresql.org/docs/current/app-psql.html

8.14.5 jsonb subscripting

2024-04-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-json.html Description: Using subscripts with square brackets is not supported, one must use -> or #> operators The given examples result in error: SELECT ('{"a": 1}'::jsonb)['a'

A typo?

2024-04-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpgsql-declarations.html Description: Under 43.3.1, "Notice that we omitted RETURNS real — we could have included it, but it would be redundant." Should that be "RETURNS tax" instead of "

RE: ts_headline performance note

2024-04-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/textsearch-controls.html Description: This is a followup to https://www.postgresql.org/message-id/171175476214.7104.6233899851600749789%40wrigleys.postgresql.org I am a developer on the t

LOCK docs and permissions

2024-04-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/explicit-locking.html Description: Hello, It appears that LOCK on a schema.table requires particular permissions but I can’t find which ones need to be granted in a schema.table in order

pg_crypto reference

2024-04-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/pgcrypto.html Description: Hi Regarding the page for pg_crypto: https://www.postgresql.org/docs/current/pgcrypto.html A worked example would really help with this, especially for those

Need a PostgreSQL 16 developer edition for enabling vector support

2024-04-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/bug-reporting.html Description: Need a PostgreSQL 16 developer edition for enabling vector support. We want to compile a vector extension in the postgres 16 dev edition and use the vector

Wording for using the lock timeout setting

2024-04-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/runtime-config-client.html Description: Thanks for the cool product. One comment concerning the lock_timeout parameter: The documentation states here: https://www.postgresql.org/docs/16/r

ALTER TABLE atomicity with sub-commands

2024-04-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-altertable.html Description: Hello dear PostgreSQL family, It is not entirely clear (to me) that ALTER TABLE statements with comma-separated sub-commands are atomic. Despite of saying

ts_headline performance note

2024-03-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/textsearch-controls.html Description: My team recently ran into a performance issue that turned out to involve ts_headline, so I've been looking at the documentation. In 12.3.4. Highlighti

CREATE ROLE

2024-03-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-createrole.html Description: https://www.postgresql.org/docs/16/sql-createrole.html ROLE role_name The ROLE clause causes one or more specified existing roles to be automatically adde

Explain Format output specification

2024-03-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-explain.html Description: Hello Regarding the Explain command's documentation: https://www.postgresql.org/docs/current/sql-explain.html For non-text format options (JSON, YAML, XML) t

Monetary Data Types Improvement

2024-03-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-money.html Description: It's not explicitly obvious that money doesn't behave like a normal numeric type in that executing a procedure with a negative numeric value for money caus

Duplicates being removed from intarray on subtraction of another intarray

2024-03-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/intarray.html Description: Hi, I recently ran into an unusual issue with the intarray extension where if you subtract one array from another the result is *also* sorted and de-duplicated.

Locking

2024-03-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/mvcc-intro.html Description: There really needs to be an explicit warning that the following is invalid in normal read committed mode:- select foo into f from bar where id=1; f = f + 123;

What are the minimum required permissions for pg_isready

2024-03-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pg-isready.html Description: Hello, The documentation does not specify what are the minimum required permissions for setting up pg_isready . I was wondering if this could be added so

Incomplete sentence in the description for most_common_freqs

2024-03-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/view-pg-stats.html Description: https://www.postgresql.org/docs/current/view-pg-stats.html#VIEW-PG-STATS It seems the ending clarifying sentence: "(Null when most_common_vals is.)" shou

Definition of random_page_cost seems to invert correlation of that setting and seq_page_cost

2024-03-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/runtime-config-query.html Description: While reading the following section in the documentation https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-RANDOM-PAGE-COST I fou

Minor typo in Section, 27.2.8.4.

2024-03-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/warm-standby.html Description: Section, 27.2.8.4. Planning For High Availability is missing the word "the" as shown below .. "Such transaction commits may never be completed if any one of

Issue with interval calculation when adding 1 year to a non-leap year

2024-03-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-datetime.html Description: Dear PostgreSQL Developers, I have encountered a potential issue with the interval calculation when adding 1 year to a non-leap year. The behavior obs

Non-blocking synchronization in libpq using pipeline mode

2024-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/libpq-pipeline-mode.html Description: The calls to PQpipelineSync and PQsendFlushRequest may either report failure or success, but not that data could not be written as of yet because the

Clarify pg_rewind behaviour in case of no divergence

2024-03-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pgrewind.html Description: After the sentence "all other files, including new relation files, configuration files, and WAL segments, are copied in full." we should add "However, no

documentation issue: listen_addresses does NOT take a comma-separated list of host names

2024-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/runtime-config-connection.html Description: In the documentation, I read: 20.3.1. Connection Settings listen_addresses (string) Specifies the TCP/IP address(es) on which the serve

Documentation for installing Python for PL/Python

2024-03-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpython.html Description: Hi everyone, I am currently trying to install PL/Python on Windows and noticed that no documentation for that currently exists (I hope I didn't miss anything).

Ubuntu and Debian Download/Installation instructions enhancement

2024-02-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/bug-reporting.html Description: Dear PostgreSQL Documentation Team, I hope this message finds you well. As a user and admirer of PostgreSQL, I greatly appreciate the effort and detail tha

substring start position behavior

2024-02-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-string.html Description: Hey, I was confused by substring behavior today, when giving 0 as a start position. I understand now that string indices are 1-based, have a certain fle

Typos in dectoint() and dectolong() function's descriptions

2024-02-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ecpg-informix-compat.html Description: Chapter 36. ECPG — Embedded SQL in C 36.15. Informix Compatibility Mode The first sentence in dectoint() and dectolong() function's descriptions con

incorrect order? in "D.1. Supported Features" of PostgreSQL 16 manual

2024-02-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/features-sql-standard.html Description: In "D.1. Supported Features"(https://www.postgresql.org/docs/current/features-sql-standard.html), identifiers appear as following: F302

return type marked optional but isn't

2024-02-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createfunction.html Description: the documentation for creating a function shows [ RETURNS rettype | RETURNS TABLE ( column_name column_type [, ...] ) ] but returns is not optional. At

Missing | ?

2024-02-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-security-label.html Description: Hi, FOREIGN TABLE object_name ...probably should have a following "|", I think? Cheers Tim

Stats and the query results on examples seem wrong

2024-02-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/bloom.html Description: Created the table with exact scripts provided and the index size was; SELECT pg_size_pretty(pg_relation_size('btreeidx')); 386 MB SELECT pg_size_pretty(pg_relation

Broken link in pgcrypto documentation

2024-02-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/pgcrypto.html Description: I was going through the links in pgcrypto documentation and I realized that one of the links at Useful Reading section do not work. interhack.net seems to be do

bgwriter_delay

2024-02-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/runtime-config-resource.html Description: Would be nice to add the limits to the doc, according to my pg15 instance I can't set bgwriter_delay more than 1 ms. (I set it to 60 s and got

text and varchar are not equivalent

2024-02-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-character.html Description: The documentation implies that the data types text and varchar are equivalent, but this is not the case with this test in Postgresql version 16. CREATE

Pathetic pedantry

2024-02-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-createdatabase.html Description: Hi, [ STRATEGY [=] strategy ] ] ...has a superfluous ], I think? Tim

Add a different archive_command example for Linux / Unix

2024-02-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/bug-reporting.html Description: Hello, in https://www.postgresql.org/docs/16/continuous-archiving.html#BACKUP-ARCHIVING-WAL the example given could be improved for Linux / Unix environment

20.5.1

2024-02-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/runtime-config-wal.html Description: The sentence in commit_siblings "A larger value makes it more probable that at least one other transaction will become ready to commit during the delay

  1   2   3   4   5   6   7   8   9   10   >