Consistency of units (bits vs bytes)

2022-11-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-uuid.html Description: One can describe the size of datatypes in the common units of bits or bytes. It'd be desirable to be consistent. Please reference these two pages... https:

temporary file size clarification

2022-11-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/runtime-config-logging.html Description: The setting log_temp_files will enable logging of the usage of temporary files, including their size in the log files. The setting is given in kil

Merge statement

2022-11-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-merge.html Description: From the description it looks like a single WHEN clause is accepted, which is definitely not true. Please let us know how many WHEN clauses are accepted for eac

Logical replication missing information

2022-11-17 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: There are several things missing here and some of them I found to be highly important: 1. How can I find why a logical replication failed.

Alignment issue at 43.10. Trigger Functions

2022-11-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpgsql-trigger.html Description: Type alignment issue for salary at "Example 43.4. A PL/pgSQL Trigger Function for Auditing": CREATE TABLE emp_audit( operation char(1) NOT

https://www.postgresql.org/docs/15/tutorial-agg.html

2022-11-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-agg.html Description: city | max | count -+-+--- Hayward | 37 | 5 (1 row) it's not right SELECT city, max(temp_lo), count(*) FILTER (WHERE temp_lo < 30)

Code example not following convention

2022-11-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-window.html Description: in: https://www.postgresql.org/docs/current/tutorial-window.html The example involving the RANK() function displays it in lower-case, which is misleading

Installing PostgreSQL 11 from source on Windows

2022-11-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/index.html Description: I tried following the instructions on chapter 17 about the "Installation From Source Code on Windows" but they seem a bit confusing at practice when having to work

"jsonb ? text" operator and JSON strings

2022-11-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-json.html Description: The description of the "jsonb ? text" operator in table 9.45 specifies its behavior when the jsonb value is an object or an array, but not when it is a str

Explanation of the ROUND function with NUMERIC as an argument

2022-12-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/bug-reporting.html Description: I think the manual's description of the round function with numeric as an argument is different from the actual behavior. manual https://www.postgresql.org

Show creating extension before using

2022-12-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/citext.html Description: On https://www.postgresql.org/docs/current/citext.html in "F.10.2. How to Use It", it says "here's a simple example of usage" and begins by creating a table with a

Minor typo in sentence saving visits to heap

2022-12-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/indexes-multicolumn.html Description: In the documentation on https://www.postgresql.org/account/comments/new/15/indexes-multicolumn.html/ ``` Constraints on columns to the right of these

Getting started

2022-12-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/user-manag.html Description: https://www.postgresql.org/docs/current/tutorial-createdb.html The "getting started" page skips right from the installing to already having started the progra

Encryption in DataBase level

2022-12-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/encryption-options.html Description: Is it recommended for full database-level encryption and decryption? What are the disadvantages of full DB-level encryption? If there is no issue with

No multi range functions on version 12

2022-12-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/rangetypes.html Description: Hello, according to the documentation, Postgres 12 should have multi range functions. However, in my installation of Postgres 12.12, I don't have any multi ran

'value' has special behaviour in alter system

2022-12-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-altersystem.html Description: Documentation say ALTER SYSTEM SET configuration_parameter { TO | = } { value | 'value' | DEFAULT } The variant 'value' has special, not obvious behaviou

missing command?

2024-10-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/reference-client.html Description: Hi, In this list of commands: https://www.postgresql.org/docs/current/reference-client.html Should this one be included? --> pg_ctl Saludos. Jose

CLUSTER command

2024-10-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-cluster.html Description: The documentation does not say what happens if you do "CLUSTER tablename" and omit the USING clause, which is shown as optional in the BNF, if I'm reading it

ALTER INDEX documentation is incomplete

2024-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-alterindex.html Description: I am trying to find out whether the syntax `ALTER INDEX name ATTACH PARTITION index_name` accepts a schema-qualified index_name. However, there is no furth

(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:

pg_prewarm can handle indexes

2024-10-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/pgprewarm.html Description: IMHO, in the pg_prewarm documentation, it should be mentioned that it can prewarm indexes as well, if given an index name as input. https://www.postgresql.org

Savepoint

2024-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/16/sql-insert.html Description: https://www.postgresql.org/docs/16/sql-insert.html#SQL-ON-CONFLICT In section on conflict nothing that there will be implicit savepoint (sub transaction). But

"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

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

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

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

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

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

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

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

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

I use the example in this page ,but got error

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

The option was not described: connection-option

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

[Issue] Getting started not oppening.

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

Count parameter for cursor_to_xml

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

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

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

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

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 …

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,

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

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

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.

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

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

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

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.

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

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

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

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

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 (

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

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

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

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

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

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

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

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__

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

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

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

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

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;

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

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

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

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

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

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

"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 [, ..

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/

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

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

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

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: '

<    7   8   9   10   11   12   13   >