Tutorial from Chapter 2.1

2025-08-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-sql-intro.html Description: Hi! I am in the process of studying your DBMS. And everything was fine with me until the moment when the tutorial in Chapter 2.1, which is proposed nee

Wrong Installation Link

2025-08-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-install.html Description: In Chapter 1 Section 1 (Installation), the documentation is linking to Chapter 17 for installing postgresql, however that chapter is titled: "Installatio

Removing publicly-writable schemas from search_path with ECPG

2025-08-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ecpg-connect.html Description: Hello, This comment relates to the last paragraph of section 34.2.1 of the Postgres 16 documentation. I am learning to use ECPG and trying to follow best p

Duplicated name of subsection 29.5.1

2025-08-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/logical-replication-col-lists.html Description: In section 29.5. Column Lists there are two identical subsections '29.5.1. Examples', with the same link

add alias FLOAT for double precision

2025-08-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/datatype.html Description: In table 8.1 ( https://www.postgresql.org/docs/current/datatype.html#DATATYPE-TABLE ) the FLOAT alias isn't listed, I think it would make sense to include beside

further clarification: alter table alter column set not null - table scan is skipped

2025-07-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/docguide.html Description: Hello there, I like PostgreSQL a lot so this is my way of giving back. The "table scan is skipped" optimization can use some clarification https://www.postgresq

Clarification on the column order of UNION, INTERSECT, and EXCEPT

2025-07-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/queries-union.html Description: When combining queries with UNION, INTERSECT, or EXCEPT, columns are matched in the order in which they occur, and not by column name. This can be unexpecte

Suggestion: Change link in tutorial to go to chapter 16 for binary installation

2025-07-23 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: On the “Installation” page of the PostgreSQL 16 tutorial ([https://www.postgresql.org/docs/16/tutorial-install.html](https://www.postgresql.org/docs/16/t

Description of disallowed characters in quoted identifiers is incomplete

2025-07-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-syntax-lexical.html Description: Section 4.1.1 of the documentation claims that "Quoted identifiers can contain any character, except the character with code zero." However according t

Suggested Feedback for PostgreSQL Documentation

2025-07-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-default.html Description: https://www.postgresql.org/docs/17/ddl-default.html uggested Feedback for PostgreSQL Documentation: In section 5.2 where the nextval() function is introduce

Plus sign in column 'Access privileges' of command \dp

2025-07-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-priv.html Description: The last table of page https://www.postgresql.org/docs/current/ddl-priv.html shows that column ' Access privileges' can contain plus-signs at the end, but what t

Creating Database Querry in psql CLI

2025-07-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-createdb.html Description: The querry to create database you mentioned in this document (createdb db_name) is not working in my Debian OS , rather create database db_name; is wo

Add example to sort results by two composite types

2025-07-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/rowtypes.html Description: The doc has example: All of these ORDER BY clauses specify the row's composite value, resulting in sorting the rows according to the rules described in Section 9

Unclear wording

2025-07-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-schemas.html Description: In §5.10.3 these two sentences seem inconsistent: > When objects are referenced in any other context without schema qualification...the search path is traver

please define 'statement' in the glossary

2025-07-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/glossary.html Description: Hello, the glossary (https://www.postgresql.org/docs/current/glossary.html) does not define 'statement' but a definition would be important to understand other c

the docs for NOTIFY do not mention the global lock that NOTIFY takes

2025-07-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-notify.html Description: The authors of the following article got stuck and had to read postgres' source code to realize that NOTIFY takes a global instance lock: https://www.recall.ai

correction suggestion for https://www.postgresql.org/docs/17/auth-username-maps.html

2025-07-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/auth-username-maps.html Description: Dear all, Pls. let me suggest the correction for the https://www.postgresql.org/docs/17/auth-username-maps.html page. It has the following sentence: '

Unexpected behaviour: it was documented to return the same value

2025-07-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-admin.html Description: set_config ( setting_name text, new_value text, is_local boolean ) → text Sets the parameter setting_name to new_value, and returns that value. If is_loca

2.4 Tutorial COPY weather.txt -- From where?

2025-07-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-populate.html Description: I'm trying to read the docs/tutorial from start to finish, and I made it to the end of "2.4. Populating a Table With Rows" before getting confused. and

No information about the internal implementation for RLS

2025-06-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-rowsecurity.html Description: https://www.postgresql.org/docs/current/ddl-rowsecurity.html The document does not contain any information how RLS are applied to the main WHERE and how t

Deprecated openssl command option in documentation

2025-06-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ssl-tcp.html Description: Hi In the documentation at https://www.postgresql.org/docs/17/ssl-tcp.html, it says, in 18.9.5. Creating Certificates: ``` To create a simple self-signed certific

wrong statement in the https://www.postgresql.org/docs/current/predefined-roles.html

2025-06-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/predefined-roles.html Description: Page: https://www.postgresql.org/docs/current/predefined-roles.html Wrong statement: "Administrators (including roles that have the CREATEROLE privilege)

Query to identify all collations in the current database that need to be refreshed

2025-06-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-altercollation.html Description: On the alter collation docs [1], it says "The following query can be used to identify all collations in the current database that need to be refreshed

ALTER DATABASE lacks documentation of REFRESH COLLATION VERSION

2025-06-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-alterdatabase.html Description: The documentation of ALTER DATABASE mentions four forms and then skips to "The remaining forms change the session default for a run-time configuration v

logial replication - drop subscription.

2025-05-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-droppublication.html Description: Hi, I'm using a lot the logical replication. I have to do some DDL changes, via an automatic process, on the primary. That process drop the existing p

Documentation should state what happens, when a commit fails

2025-05-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-commit.html Description: Deferrable constraints, deadlocks and possibly other deferred or lazily evaluated rules are checked upon commit. What happens if they are not met and the commi

Hot standbys now support exporting snapshots while creating a logical replication slot

2025-05-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/logicaldecoding-explanation.html Description: Hi, I'm referring to this bit at the very end of the page: Creation of a snapshot is not always possible. In particular, it will fail when con

Postgres jsonb data

2025-05-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-json.html Description: Documentation suggests that a json type of null doesn't turn into anything when read into a jsonb, because the json type of null doesn't correspond to the p

reindex documentation

2025-05-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-reindex.html Description: The following paragraph: "If the index marked INVALID is suffixed ccnew, then it corresponds to the transient index created during the concurrent operation, a

Missing word

2025-05-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-partitioning.html Description: In the paragraph: https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE-MAINTENANCE, sentence "Another option that i

Wrong documentation link for a newcomer

2025-05-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-install.html Description: Document links to Chapter 17 for Postgresql installation. But Chapter 16 is the proper link for a newcomer. 1.1. Installation https://www.postgresql.org/

"GRANT on Roles" supports multiple options

2025-05-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/docguide.html Description: Hi! In the documentation of the GRANT[1] command, the Synopsis for "GRANT on Roles" command is incomplete. Quoting from the current docs: GRANT role_name [, ..

Using "make" command in Windows through MinGW

2025-05-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-sql-intro.html Description: Chapter 2.1 "Introduction". -- I would like to add how to use "make" command on Windows for creation of sql files. Chapter 2.2 "Running 'make' comman

RE: Changes in CREATE EXTENSION from being an extension to statement

2025-05-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-createextension.html Description: I wonder if it is appropriate to use "CREATE EXTENSION is a PostgreSQL statement." instead of "CREATE EXTENSION is a PostgreSQL extension."

29.2. Subscription

2025-04-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/logical-replication-subscription.html Description: Hi, https://www.postgresql.org/docs/17/logical-replication-subscription.html#LOGICAL-REPLICATION-SUBSCRIPTION-EXAMPLES Firstly - a big th

Data visibility for returning statement

2025-04-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/dml-returning.html Description: Today I found a pretty special use-case for the "RETURNING" functionality, which I cannot find documentation for? If you have a statement as follows: UPDATE

Documentation correction suggestion for primary key hashing on partitioned tables

2025-04-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-partitioning.html Description: https://www.postgresql.org/docs/current/ddl-partitioning.html / 5.12.2.3. Limitations says: > To create a unique or primary key constraint on a partitio

Please clarify docs on user-defined settings for SET and RESET

2025-04-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-set.html Description: Hello, I'm reading through and playing with the SET and RESET docs and I'm somewhat unclear about the behavior of arbitrary user settings that *don't* have a ses

Dependency Tracking

2025-04-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-depend.html Description: (ddl-depend.html) > PostgreSQL will be aware that the get_color_note function depends on the rainbow type: dropping the type would force dropping the function,

Hyperlink to Logical replication slots instead of physical

2025-04-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/logical-replication-subscription.html Description: I think there is a mistake in this doc : https://www.postgresql.org/docs/current/logical-replication-subscription.html "Each subscriptio

gen_random_uuid random source clarification

2025-04-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-uuid.html Description: In reference to the documentation for gen_random_uuid at: https://www.postgresql.org/docs/17/functions-uuid.html It would be good to add a comment about th

Missing "each" in `NegotiateProtocolVersion` protocol message format description

2025-04-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/protocol-message-formats.html Description: Dear Postgres Team, There seems to be a missing "each" in documentation for the `NegotiateProtocolVersion` message format: *Then, for [each] pro

generated constraint name

2025-04-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-alter.html Description: url: https://www.postgresql.org/docs/current/ddl-alter.html#DDL-ALTER-REMOVING-A-CONSTRAINT (If you are dealing with a generated constraint name like $2, don't

Suggestion for docs, section "4.2.3 Subscripts": bounds and base

2025-04-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-expressions.html Description: I skimmed over section 4.2 while waiting for a meeting to start and found no mention of the following two questions that immediately pop up in my mind whe

Ambiguity in IS JSON description and logic

2025-04-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-json.html Description: On the manual page https://www.postgresql.org/docs/current/functions-json.html, in the Table 9.48. "SQL/JSON Testing Functions" there is a description of I

SEQUENCE keyword is option on GRANT

2025-03-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-grant.html Description: The documentation indicates that they keyword SEQUENCE must precede the sequence_name in a GRANT, but in my experience it is optional: colin@adinkra:~$ psql ps

Creating first database

2025-03-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-createdb.html Description: In the Getting Started section of the documentation which would be used by a new user immediately after installing PostgreSQL, the user is asked to run

Documentation for initdb option --waldir

2025-03-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/app-initdb.html Description: Hi all, During troubleshooting with a customer we found that it might help to know that initdb will create a symbolic link from data/pg_wal to the custom dire

3.3. Foreign Keys

2025-03-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-fk.html Description: While going through the documentation in a sequential manner, attempting to create TABLE cities creates an error as “relation cities” already exists. I am sti

pg_dump/pg_restore exit status codes

2025-03-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/app-pgdump.html Description: From the documentation, it's unclear to me whether `pg_dump`/`pg_restore` CLI commands ever use non-zero exit status codes, and if so when. My assumption is th

Binary Installation Docs

2025-03-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-install.html Description: Could we add a reference to the binary installation on this page? https://www.postgresql.org/docs/current/tutorial-install.html

pg_basebackup restore

2025-03-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/app-pgbasebackup.html Description: Hello! Is there any way to restore pg_basebackup ? Reading current documentation on pg_basebackup I could not find any "restore" word in it. Thank you

parameter log_connections can not be changed at session start

2025-03-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/bug-reporting.html Description: Parameter: log_connections. "Only superusers and users with the appropriate SET privilege can change this parameter at session start, and it cannot be chang

Except does not work as in the documentation

2025-02-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/queries-union.html Description: The current documentation does not give the right syntax for using the EXCEPT in a query. This is the error when I ran the below: select appt_id from wayfin

correction

2025-02-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/routine-vacuuming.html Description: hi i found a tiny error below: https://www.postgresql.org/docs/current/routine-vacuuming.html >Drop any old replication slots. Use pg_stat_replication t

pg_copy_logical_replication_slot doesn't copy the failover property

2025-02-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-admin.html Description: The documentation for pg_copy_logical_replication_slot doesn't mention that the failover property for the logical slot is not copied. I assumed there was

Threading issue / maybe just doc issue.

2025-02-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/libpq-threading.html Description: commit https://github.com/postgres/postgres/commit/515112f9d4874aaedd0c093f41c0ba3e0bf7f660 added global variables for backward compatibility support: sta

Copy paste error

2025-02-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/multivariate-statistics-examples.html Description: CREATE STATISTICS stts (dependencies) ON a, b FROM t; ANALYZE t; EXPLAIN (ANALYZE, TIMING OFF) SELECT * FROM t WHERE a = 1 AND b = 1;

incorrect error message

2025-02-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-alterrole.html Description: After changing to user postgres, I tried to launch psql shell as a new user ( -U). However the error message I received after I used an incorrect password w

Text correction

2025-02-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/textsearch-intro.html Description: The page: https://www.postgresql.org/docs/17/textsearch-intro.html The original sentence: "The form text @@ tsquery is equivalent to to_tsvector(x) @@ y.

Second paragraph a little bit misleading

2025-02-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/checksums.html Description: Hi there, I think that the first sentence of the second paragraph in this page is a little bit misleading. The first paragraph states that checksums are not en

Regarding experiencing

2025-02-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-admin.html Description: In this session of REFERENCE :9.28.10. Advisory Lock Functions The functions shown in Table 9.106 manage advisory locks. For details about proper use of

When to use USING on DELETE could use more clarity

2025-02-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-delete.html Description: Referring to this page of the docs: https://www.postgresql.org/docs/current/sql-delete.html This comment is at the bottom of the Notes section: "In some

Regarding explanation to store and retrieve postgres geometric features

2025-02-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/datatype-geometric.html Description: I have found section for 8.8. Geometric Types 8.8.1. Points 8.8.2. Lines 8.8.3. Line Segments 8.8.4. Boxes 8.8.5. Paths 8.8.6. Polygons 8.8.7. Circles

Minor suggestions for docs regarding json_table

2025-02-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-json.html Description: In https://www.postgresql.org/docs/current/functions-json.html#FUNCTIONS-SQLJSON-TABLE 1. There is unused `PASSING` argument `filter2` Consider: ```sql S

creating a database

2025-02-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-createdb.html Description: Dear, I was reading intro to setup of postgresql, and looking at https://www.postgresql.org/docs/current/tutorial-createdb.html#TUTORIAL-CREATEDB Reg

timestamp with time zone ~> GMT

2025-01-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/datatype-datetime.html Description: Thank you for postgres. I wanted to offer clarification would may help others in the docs on time stamps (after discovering subtle issues have significa

https://www.postgresql.org/docs/current/kernel-resources.html

2025-01-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/kernel-resources.html Description: The following: Another approach, which can be used with or without altering vm.overcommit_memory, is to set the process-specific OOM score adjustment va

Request for Formal Syntax of WHERE Clause Conditions

2025-01-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-select.html Description: Dear PostgreSQL Team, I am building a PostgreSQL parser and need a precise reference for the formal syntax of condition used in the WHERE clause. While the do

Typo on tutorial window page

2025-01-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-window.html Description: EXPECTED: As shown here, the rank function produces a numerical rank for each distinct PARTITION BY value in the current row's partition, using the order

Improve examples: Provide the example which extend to the left of the range

2025-01-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/functions-range.html Description: Hi. All examples on this page uses `not extend` expression: ``` anyrange &< anyrange → boolean Does the first range not extend to the right of the secon

[Appendix C. SQL Key Words] Missing keywords

2025-01-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-keywords-appendix.html Description: https://www.postgresql.org/docs/current/plpgsql-control-structures.html It miss some control structure keywords like at least (but not limited to)

Broken links in documentation

2025-01-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/isn.html Description: The following pages have errors: https://www.postgresql.org/docs/current/isn.html - 404 error: link to https://www.ismn-international.org/ranges.html - 404 error: li

LC_COLLATE is visible in the documentation for PostgreSQL 17, but it is not supported

2025-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-show.html Description: On the docs page for SHOW (https://www.postgresql.org/docs/17/sql-show.html), LC_COLLATE is listed as a parameter which can be shown, but trying to run SHOW LC_C

Some comments on PL/Python documentation

2025-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/plpython-data.html Description: Hello, In my opinion, some phrases on this page are not quite correct. 44.2.4. Composite Types You say: '...Object (any object providing method __getattr__

Parameter NOT NULL to CREATE DOMAIN not the same as CHECK (VALUE IS NOT NULL)

2025-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-createdomain.html Description: The manual claims: The syntax NOT NULL in this command is a PostgreSQL extension. (A standard-conforming way to write the same would be CHECK (VALUE IS

vm.overcommit_ratio

2025-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/kernel-resources.html Description: PostgreSQL documentation point to kernel documentation for info about vm.overcommit_ratio. But kernel documentation slightly incorrect, so may be write s

Typo in doc page?

2025-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-keywords-appendix.html Description: I could be mistaken but, in the following documentation page: https://www.postgresql.org/docs/current/sql-keywords-appendix.html there seems to be a

docs are incomplete or wrong...

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

clarify which fields are signed int and which ones are unsigned

2024-12-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/protocol-message-formats.html Description: I don't see it clearly stated which Int fields are signed and which are unsigned. If it can be assumed that Int is signed and Byte is unsigned th

next method of Python iterators

2024-12-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/plpython-data.html Description: Method `next` of an iterator should be named `__next__` instead.

Formal Syntax of PL/pgSQL

2024-12-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/index.html Description: I am currently working on a project that involves analyzing and building AST (Abstract Syntax Tree) interfaces for PL/pgSQL in TypeScript. My goal is to model the e

Does NOTIFY leak information?

2024-12-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-notify.html Description: Hi, The documentation (https://www.postgresql.org/docs/17/sql-notify.html) for the NOTIFY command begins with the following statements: The NOTIFY command se

34.3.2. Using Cursors

2024-12-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ecpg-commands.html Description: I think there is a missing colon in the example code "Select using cursors": EXEC SQL DECLARE foo_bar CURSOR FOR SELECT number, ascii FROM foo ORDE

pg_createsubscriber: publication-name and subscription-name options do not exist

2024-11-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/app-pgcreatesubscriber.html Description: The page https://www.postgresql.org/docs/17/app-pgcreatesubscriber.html mentions these two options: “If publication-name option is not specified …

Creation of extensions and Backend C/C++ functions.

2024-11-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/xfunc-c.html Description: I can and have implemented triivial C/C++ functions to compile and link to Postgres. An example follows:- #include "postgres.h" #include "fmgr.h" #ifdef PG_MOD

Clarification Needed on VARIADIC Keyword Explanation

2024-11-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/plpgsql-overview.html Description: The current documentation for the VARIADIC keyword in PostgreSQL contains an incorrect statement. It says that VARIADIC "prevents expansion of the functi

Misprints in code

2024-11-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/plpython-data.html Description: https://www.postgresql.org/docs/16/plpython-data.html#PLPYTHON-DATA-SET-RETURNING-FUNCS The code contains a misprint in the following section:Iterator (

wal_compression = on: what is the algorithm?

2024-11-15 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: In https://www.postgresql.org/docs/16/runtime-config-wal.html#GUC-WAL-COMPRESSION, the option "on" is not described: “The supported methods are pglz,

CREATE UNIQUE INDEX name ON table (column [, ...]) [ NULLS [ NOT ] DISTINCT ];

2024-11-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/indexes-unique.html Description: This says it works from 12 onwards but actually from 15 onwards Prior to 15 unique partial indexes needed creating, e.g. (parent_ID, NAME) where parent_ID

Documentation error in tutorial page for Window Functions

2024-11-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/tutorial-window.html Description: In Section 3.5 Window Functions, the sentence that currently says: "As shown here, the rank function produces a numerical rank for each distinct ORDER BY

Improved security for https://www.postgresql.org/docs/current/install-make.html

2024-11-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/install-make.html Description: The current 'short' version is ``` ./configure make su make install adduser postgres mkdir -p /usr/local/pgsql/data chown postgres /usr/local/pgsql/data su

Serializable Transaction Anomoly

2024-11-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/transaction-iso.html Description: I discovered an oddity in Serializable Transaction behavior and while referencing the current docs there is a possible contradiction and I'm not sure if t

https://www.postgresql.org/docs/current/sql-insert.html

2024-11-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-insert.html Description: Hi, the example found in the doc above: WITH upd AS ( UPDATE employees SET sales_count = sales_count + 1 WHERE id = (SELECT sales_person FROM accounts W

PostgreSQL limits

2024-11-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/limits.html Description: I think it can be useful to add the maximum SQL statement length that PostgreSQL can handle in the Appendix K. PostgreSQL Limits. If I'm not wrong it is 2147483648

fir for row level security

2024-11-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/ddl-rowsecurity.html Description: Cite When multiple policies apply to a given query, they are combined using either OR (for permissive policies, which are the default) or using AND (for r

psql command

2024-10-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/index.html Description: God Dammit this " \! clear " command is pissing me off . Only " cls " to clear the screen seems very much Comfortable man

Documentation mistake?

2024-10-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/indexes-bitmap-scans.html Description: In page https://www.postgresql.org/docs/current/indexes-bitmap-scans.html написано следующее: "Another example is that if we have separate indexes on

"5.3. Identity Columns" Incorrect Usage of "VALUE" in Documentation

2024-10-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/ddl-identity-columns.html Description: In the PostgreSQL documentation regarding identity columns, the SQL syntax examples incorrectly use the keyword "VALUE" instead of "VALUES". This err

(Very minor) Link towards the 'bug-submission' web form

2024-10-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/bug-reporting.html Description: This document contains the sentence "Another method is to fill in the bug report web-form available at the project's web site.", where "web site" is a link:

  1   2   3   4   5   6   7   8   9   10   >