Unclear guarantees about sort order on https://www.postgresql.org/docs/current/queries-order.html

2023-10-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/queries-order.html Description: The document only says this about unsorted queries: > After a query has produced an output table (after the select list has been processed) it can optional

Missing closing ]

2023-10-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/rangetypes.html Description: In the example session at https://www.postgresql.org/docs/current/rangetypes.html#RANGETYPES-EXAMPLES there are missing closing square bracket ] Take a look

This is too implicit that recovery.signal will be removed

2023-10-05 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: Hello. On the page https://www.postgresql.org/docs/current/runtime-config-wal.html Actual: >To start the server in targeted recovery mode, create a fil

It is not clear from documentation when and how I should restore base backup

2023-10-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/continuous-archiving.html Description: Hello. On page: https://www.postgresql.org/docs/current/continuous-archiving.html#BACKUP-PITR-RECOVERY Is is not clear should I do additional action

Example numeric constants aren't valid?

2023-10-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-syntax-lexical.html Description: Hi, Re. Docs page: https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS-NUMERIC I noticed that the following are spec

Show how to incrementally make a column NOT NULL

2023-10-10 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: In the examples on https://www.postgresql.org/docs/current/sql-altertable.html#SQL-ALTERTABLE-NOTES, I suggest adding the following. To make an existing c

Setting up WAL archiving

2023-10-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/continuous-archiving.html Description: Hi, In section 'WAL archiving setting (parameter archive_command) I always use, in Unix, the option '-p' on the cp command, to keep the date and ti

Improve documentation for 'recovery_target' option

2023-10-10 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: Hello. On page: https://www.postgresql.org/docs/16/runtime-config-wal.html#GUC-RECOVERY-TARGET It is spelled: This parameter specifies that recovery sh

Wrong article SET AUTOCOMMIT

2023-10-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/ecpg-sql-set-autocommit.html Description: This article should be removed as this parameter does not exist since a long time version 9.4

31.7.1. Initial Snapshot

2023-10-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/logical-replication-architecture.html Description: There are dublicated section named "31.7.1. Initial Snapshot" on https://www.postgresql.org/docs/16/logical-replication-architecture.html

Clarify: default precision on timestamps is 6

2023-10-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-datetime.html Description: https://www.postgresql.org/docs/current/datatype-datetime.html says: > time, timestamp, and interval accept an optional precision value p which specifi

SP-GiST confusing introductory paragraph

2023-10-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/spgist-intro.html Description: I'm confused by this paragraph: > These popular data structures were originally developed for in-memory usage. In main memory, they are usually designed as

"20.16. Customized Options" – cannot be set by `ALTER SYSTEM`

2023-10-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/runtime-config-custom.html Description: As far as I can tell, the following statement: > PostgreSQL will accept a setting for any two-part parameter name does not hold when creating a *n

No explanation of other options

2023-10-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-move.html Description: A few more examples with the other options would be helpful. MOVE LAST for example shows NULL, What does MOVE ALL do?

48.1. Logical Decoding Examples

2023-10-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/logicaldecoding-example.html Description: At the beginning of this section, please change this statement: Before you can use logical decoding, you must set wal_level to logical and max_r

Discrepancy between the documentation and the implementation

2023-10-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ecpg-sql-set-connection.html Description: In the documentation for Postgres 15, on page https://www.postgresql.org/docs/15/ecpg-sql-set-connection.html, it states that one can write: SET

19.9. Secure TCP/IP Connections with SSL

2023-10-26 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: There is no mention of key lengths on the manual page about SSL/TLS connections even though there are restrictions. It probably depends on the build which is why

pg_isready --dbname option is broken. So it should not be in the manual

2023-10-26 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: the --dbname option in pg_isready seems not to work propperly. the tool returns 'ok' as long as the cluster itselft is running, no matter how wrong the bdn

Full Text Search

2023-10-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/textsearch-limitations.html Description: Hello, In the FTS/Limitations part of the documentation, it says : "Another example — the PostgreSQL mailing list archives contained 910,989 uniq

^@ operator vs start_with function

2023-10-31 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: https://www.postgresql.org/docs/16/functions-string.html Said text ^@ text → boolean Returns true if the first string starts with the second string (equi

Please make a note regarding the PL/pgSQL FOUND variable

2023-11-04 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: Since I was recently bitten by the fact that CREATE TABLE AS doesn't set the PL/pgSQL variable FOUND, it would be nice if that were explicitly noted in

jsonb array accessors

2023-11-04 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: https://dbfiddle.uk/Dr-c-nqL multiple subscripts for jsonb arrays do not behave as described on Table 8.25 in Postgres 16 docs / 8.14.7 jsonpath

Example for Unique Partial Indexes

2023-11-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/indexes-unique.html Description: I would like to request an improvement to the PostgreSQL documentation, specifically in the sections "11.6. Unique Indexes" and "11.8. Partial Indexes." C

CREATE SUBSCRIPTION issue

2023-11-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/logical-replication-row-filter.html Description: Hey I'm using create subscription to subscribe to a table. I have two different hosts and I want to setup replication between them. In host

add new acronym "AM"

2023-11-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/acronyms.html Description: while reading the progres codebase, i could find you're using the acronym "AM" which denotes "Access Method". it's be nice to add it to the list of acronyms

Missing ;

2023-11-13 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: Hi, To be consistent, the "with" example should end in a ";". WITH t AS ( SELECT random() as x FROM generate_series(1, 3) ) SELECT * FROM t UNION ALL S

T is a mandatory date time separator in RFC3339 but documentation states differently

2023-11-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/git.html Description: >ISO 8601 specifies the use of uppercase letter T to separate the date and time. PostgreSQL accepts that format on input, but on output it uses a space rather than T,

Additional Notes

2023-11-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-notify.html Description: It would be good to add to the notes section that use of NOTIFY especially within a TRIGGER requires an AccessExclusiveLock which may cause performance issues.

Mention that there will be no feedback.

2023-11-23 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: You might want to mention that createdb will give no feedback after creating database. Neither will dropdb.

"name" vs "alias" in datatype table

2023-11-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype.html Description: I think there could be some clarification of what is a "name" vs. "alias" on the datatypes table. Right now, what's in the "Aliases" column is sometimes postgre

Table-space documentation

2023-11-27 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: While reading the table-space documentation https://www.postgresql.org/docs/16/manage-ag-tablespaces.html the information I was looking for was not

Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS

2023-11-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-createtable.html Description: It is not clear to me that foreign keys are copied or not when duplicating a table using CREATE TABLE ... LIKE ... INCLUDING ALL. I had to actually test t

Aggregate functions description page should link to Aggregate Functions list page

2023-11-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-agg.html Description: There are two documentation pages with the same title "Aggregate Functions". One describes what they are and one lists all of them. The two pages should prov

Typo in '8.5. Date/Time Types' v16

2023-11-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/datatype-datetime.html Description: Hello, In the interval example outputs, for postgres and postgres_verbose. It says mons instead of months.

Restore to a new database from a backup (.tar) generated from

2023-11-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/app-pgrestore.html Description: After creating a new database in postgreSQL : CREATE DATABASE x; I dump it in a .tar file:

libpq-ssl suggestion:

2023-12-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/libpq-ssl.html Description: I noticed that it would be helpful to list the connection parameters and environment variables for the various SSL files in the table "Table 34.2. Libpq/Client

Missing "CONSTRAINT" keyword in ADD CONSTRAINT form?

2023-12-04 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: (apologies, I managed to send this too soon, just now, somehow) The example for ALTER DOMAIN shows: ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK (ch

Inconsistent information on default ordering for ORDER BY clause

2023-12-08 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: At the top of the sql-select page it says "If ORDER BY is not given, the rows are returned in whatever order the system finds fastest to produce." but later

pg_stats entries visibility with RLS enabled

2023-12-08 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: First paragraph for the pg_stats view says: "This view allows access only to rows of pg_statistic that correspond to tables the user has permission to read,

unclear wording re: spoofing prevention on network connections

2023-12-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/preventing-server-spoofing.html Description: When I read: To prevent spoofing on TCP connections, either use SSL certificates and make sure that clients check the server's certificate, or

Section 4.1.2.3 repeats information presented in section 4.1.1

2023-12-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-syntax-lexical.html Description: it just threw me off to read the exact same thing twice in quick succession, I'd suggest linking to section 4.1.2.3 in section 4.1.1 instead.

'bar' shouldn't be a string in example

2023-12-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-alterforeigndatawrapper.html Description: Hi, Re. this example: ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP 'bar'); I think "bar" is akin to "foo" and therefore should

Inconsistency in: 2.3. Creating a New Table

2023-12-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-table.html Description: The text in: 2.3. Creating a New Table, states: "... you can type the command aligned differently than above, or even all on one line. Two dashes (“--”) in

Documentation does not describes format for access privileges: =Tc/user

2023-12-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ddl-priv.html Description: Hello. The page https://www.postgresql.org/docs/current/ddl-priv.html does not describe what =Tc/user means. Also I did not find a link to appropriate page which

string_agg

2023-12-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-aggregate.html Description: Please add the argument "distinct" to the documentation of the aggregate-function "string_agg". It's used to omit any duplicates in the result string.

Postgres compilation instructions do not work on modern debian or ubuntu

2024-01-01 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, I Hope you've enjoyed a festive period. Thanks for all your hard work, postgres is amazing. Small suggestion for installation instructions on debian

Problems when using unaccent

2024-01-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/unaccent.html Description: I'm trying to query a database with unaccent, but PostgreSQL gives me exceptions: ERROR: function unaccent(character varying) does not exist at character 139 H

incorrect description of Python try / except

2024-01-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/plpython-subtransaction.html Description: On page https://www.postgresql.org/docs/current/plpython-subtransaction.html, Note that the use of try/catch is still required. should read Note

Grammar suggestion

2024-01-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/ddl-constraints.html Description: Dear postgres Team, I happened to have stumbled across a tricky to read sentence in Ch. 5.45 'Foreign Keys' (Postgres Version 15). The original senten

Supplement of procedure suggested

2024-01-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/routine-vacuuming.html Description: In https://www.postgresql.org/docs/current/routine-vacuuming.html section "25.1.5. Preventing Transaction ID Wraparound Failures" there is a 5-step pr

Creating the scripts and compiling the C files containing user-defined functions and types.

2024-01-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-sql-intro.html Description: " Directory of C:\postgresql-16.1\src\tutorial 11/06/2023 11:17 PM . 11/06/2023 11:17 PM .. 11/06/2023 11:04 PM

About COPY

2024-01-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-populate.html Description: COPY weather FROM '/home/user/weather.txt'; is not working it requires additional commands for me.

Missing information on '-X' in section 26.3.6.1.

2024-01-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/continuous-archiving.html Description: Hi! I'm reading through the documentation and so far I have to say this is the best documentation I have ever encountered, thank you! I noticed, tha

ERROR: plpython3u

2024-01-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/tutorial-join.html Description: CREATE EXTENSION plpython3u; [2024-01-25 05:56:50] [58P01] ERROR: could not load library "C:/Program Files/PostgreSQL/16/lib/plpython3.dll": The specified

It would be nice to clarify is there any point in select queries pipelining

2024-01-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/protocol-flow.html Description: Greeting! Please consider the following exchange with a PG database (Kotlin + Reactor+ r2dbc-postgresql): ``` 2951.063166127.0.0.1 50591 12

SET ROLE versus SET SESSION AUTHORIZATION

2024-01-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-set-role.html Description: "SET ROLE has effects comparable to SET SESSION AUTHORIZATION, but the privilege checks involved are quite different." What are the differences in privilege

unknown option --subject

2024-01-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/auth-pg-hba-conf.html Description: Hello. On this page this command does not work `openssl x509 -in myclient.crt -noout --subject -nameopt RFC2253` unknown option --subject We should use

Missed information about clientname=CN option

2024-01-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/auth-cert.html Description: Hello. This page missed information about supported clientname=CN/DN option and describes only `map` option. Also `clientcert` is described not in format. I ex

Possible spelling errors

2024-01-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/auth-username-maps.html Description: Hello. I am not sure, but 'can be include directives' looks very strange to me: As for pg_hba.conf, the lines in this file can be include directives, f

Broken link

2024-02-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/recovery-config.html Description: This page has a link that says "See the release notes for PostgreSQL 12 for details on this change." https://www.postgresql.org/docs/current/recovery-conf

system column

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/ddl-system-columns.html Description: Will be clear to have a picture of how they are in the database.

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

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

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

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

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

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

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

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

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

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

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

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

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

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).

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

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

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

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

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

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

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

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

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;

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.

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

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

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

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

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

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

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

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

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

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

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 "

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'

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

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

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

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