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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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.

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

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

'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

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.

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

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,

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

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

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

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:

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.

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

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

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

"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

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.

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.

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,

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

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

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

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

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

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

^@ 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

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

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

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

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

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

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?

"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

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

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

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

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

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

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

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

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

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

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

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

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

Corresponding documentation page does not mention about `spread` mode

2023-10-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pgbasebackup.html Description: Hello. On [this page](https://www.postgresql.org/docs/current/app-pgbasebackup.html) `spread` is mentioned: -c {fast|spread} --checkpoint={fast|spread}

INT4RANGE Upper bound always includes a higher number

2023-10-03 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: Hi, First I just wanted to say, the documentation is overall excellent, it has been such a pleasure learning postgres. In the RANGE types where it says the squ

unnest multirange, returned order

2023-10-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/functions-range.html Description: The doc says: * unnest ( anymultirange ) → setof anyrange * Expands a multirange into a set of ranges. The ranges are read out in storage order (ascending

missing GRANTED BY explanations

2023-09-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-revoke.html Description: Hi, In the documentation for revoke command, there is no description for GRANTED BY clause. please explain that what will happen when using this clause in revo

Not clear spelling about transaction

2023-09-30 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: >No committed transactions will be lost Hello. It is not clear to me. Did you mean: Not committed transactions will be lost Or None of committed tra

`pg_restore --if-exists` clarification

2023-09-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pgrestore.html Description: Good Morning, In the `pg_restore` docs (https://www.postgresql.org/docs/current/app-pgrestore.html), `--if-exists` states that it is to > Use conditional

correct documentation in set role

2023-09-25 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: it is good to mention that: The specified role_name must be a role that the current session user is a member of "and has SET True option on it." The second

ALTER POLICY etc locks

2023-09-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-alterpolicy.html Description: Hi folks, just wanted to drop a documentation suggestion: we document that e.g. ALTER TABLE acquires an ACCESS EXCLUSIVE lock most of the time, but there'

Typo/wording on https://www.postgresql.org/docs/current/catalog-pg-class.html

2023-09-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/catalog-pg-class.html Description: I've just read this: "catalogs tables and most everything else that has columns or is otherwise similar to a table" It seems that it should be: "catal

SSI retry strategy

2023-09-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/index.html Description: Dear Sir / Madam, according the https://www.postgresql.org/docs/current/transaction-iso.html#XACT-SERIALIZABLE a transaction must be retried if its commit failed.

pg_upgrade doc uses inconsistent versions within the doc.

2023-09-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/pgupgrade.html Description: I feel like for readability the pg_upgrade doc should use the same old_version and new_version examples when showing examples throughout the doc page. as an

Documentation does not mention that basebackup could not be used on newer major version

2023-09-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/app-pgbasebackup.html Description: https://www.postgresql.org/docs/current/logical-replication.html Logical replication has excellent paragraph about usecases. These pages does not have t

Ambiguous statement about order

2023-09-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-json.html Description: The following statement in the page doesn't speak about arrays which created some confusion with developers in our company: "By contrast, jsonb does not pre

index access method documentation light on details on ii_AmCache

2023-09-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/index-functions.html Description: So, if I cache something in ii_AmCache during a call to my aminsert callback... When, if ever, does it get freed? Having looked at example code, I don't

Kernel settings shmall

2023-09-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/kernel-resources.html Description: Hi. The kernel parameter shmall is only in pages in Linux but your documentation says it can also be in bytes. Maybe it's in bytes with some OS other tha

Clarification of deadlock possibilities in section 13.3.5. Advisory Locks

2023-09-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/explicit-locking.html Description: Hi, An example from section 13.3.5. Advisory Locks (I included the ORDER BY for deterministic results): SELECT pg_advisory_lock(q.id) FROM ( SELECT id

Error in Example

2023-09-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/indexes-partial.html Description: The IP addresses used to exemplify which one will be covered by the partial index are inverted.

General Feedback

2023-08-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-createschema.html Description: "To create a schema, the invoking user must have the CREATE privilege for the current database. (Of course, superusers bypass this check.)" - maybe you c

CREATE TRIGGER documentation inconsistensies

2023-08-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createtrigger.html Description: In PostgreSQL 14 and 15 (previous versions I've not checked) is stated that CREATE TRIGGER statement is as follows: CREATE [OR REPLACE] [CONSTRAINT] TR

There is no description about "Logical Replication also use or occupy max_wal_senders ",

2023-08-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/runtime-config-replication.html Description: hello ,everyone, in the url https://www.postgresql.org/docs/15/runtime-config-replication.html, there are following description: max_wal_sen

Create Role Documentation - Not Clear for new users

2023-08-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/database-roles.html Description: Hi! Hope you are doing great! I'm trying to learn about PostgreSQL, I'm totally new, and I think that for people like me, the documentation is not clear,

Wrong statement on the materialized views page

2023-08-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/rules-materializedviews.html Description: There might be an issue on this page: https://www.postgresql.org/docs/current/rules-materializedviews.html I think the statement CREATE TABLE my

In docs there is no "Installation from Binaries" section

2023-08-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/install-binaries.html Description: Installing software from ZIP archive is a common practice, pgsql provides such archive, but doesn't provide instructions on what to do with it. These pa

ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error

2023-08-20 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: Hi, When the folloing SQL is executed: ALTER TABLE "table" ALTER COLUMN "id" SET RESTART WITH nnn raises error then an error is returned: > ERROR: seque

Include rust as an externally maintained procedural language

2023-08-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/external-pl.html Description: The documentation [1] contains a list of independently maintained procedural languages. Recently, PL/Rust [2] has reached its version 1.0 [3] and appears to b

Include PostgresNIO Swift client in the Documentation

2023-08-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/external-interfaces.html Description: Hi, I'm reaching out to ask if the Swift Postgres could be included in the listing here: https://www.postgresql.org/docs/current/external-interfac

U+200B ZERO WIDTH SPACE (0xe2 0x80 0x8b) in PostgreSQL documentation

2023-08-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/infoschema-administrable-role-authorizations.html Description: In official html documentation there are issue U+200B ZERO WIDTH SPACE (0xe2 0x80 0x8b) in text of some keywords, some iden

With recusive miss syntax definition

2023-08-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/queries-with.html Description: In this page seems to miss link to with sintax. Specially for with recursive. I'm looking for an more complicated example like that: with first_query as ( ),

3.6 Inheritance Documentation

2023-08-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-inheritance.html Description: The documentation for inheritance in PostgreSQL is not entirely accurate in the given example. In the provided example, the cities table and the cap

word incorrectly on document

2023-08-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/executor.html Description: Document location: 52.6. Executor fed up -> feed up

to_char(numeric type, text) rounding instead of truncating

2023-07-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/functions-formatting.html Description: I've encountered an issue with to_char(numeric type, text) Apparently, it uses rounding instead of truncation which leads to unpexpected results. Thi

Uniquness of ctid

2023-07-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/ddl-system-columns.html Description: Hi, Looking at the explanation abour ctid, it is "The physical location of the row version within its table. " From that line, I think ctid is unique i

CREATEROLE Inheritance

2023-07-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/role-membership.html Description: Regarding this paragraph: "The role attributes LOGIN, SUPERUSER, CREATEDB, and CREATEROLE can be thought of as special privileges, but they are never inhe

IN for records

2023-07-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/functions-comparisons.html Description: In section #FUNCTIONS-COMPARISONS-IN-SCALAR operator IN is described as a expression for scalars, and as a shorthand notation for a combination of o

Improvement of clarity in pg_ctl command docummentation

2023-07-16 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 was reading the documentation about pg_ctl and there everything was well written about the usage and option that can be used with the pg_ctl command but ther

Confusing reference to MERGE use inside WITH

2023-07-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/queries-with.html Description: Hi. In the queries WITH documentation https://www.postgresql.org/docs/15/queries-with.html it is a bit confusing that MERGE is referenced in several places

transaction example just pathetic

2023-07-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-transactions.html Description: The explanation of transactions is pathetic. Why are you showing bad design...then saying it doesn't matter. And then in your transaction block,

group by can use alias from select list

2023-07-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-select.html Description: hi i have a discussion in pgsql-b...@lists.postgresql.org about this and it is mentioned in the answers that it is documented and a "feature" of Postgres that

bad choice of the word in sentence

2023-06-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/transaction-iso.html Description: https://www.postgresql.org/docs/current/transaction-iso.html#XACT-READ-COMMITTED Quote: "<...>When a transaction uses this isolation level, a SELECT quer

Change "two" to "three" for decades of development in history

2023-06-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/history.html Description: Hi, In https://www.postgresql.org/docs/current/history.html it is written "With over two decades of development behind it". But since "The implementation of POST

streaming replication depends on matching glibc versions / LOCALE sort order

2023-06-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/warm-standby.html Description: After suffering a database corruption, I went looking for mention of the cause or "prevention tips" in the official docs. tldr; The following section might

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