Addition of Github link to odument

2022-12-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-sql-intro.html Description: I feel, for the viewers or learners of Postgresql will be benetial to add the link to the /src/tutorial on PostgreSQL's GitHub page will be easier to d

tar command example for backup file

2022-12-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/backup-file.html Description: It would be nice to change the tar command example to: tar -cf backup.tar -C /usr/local/pgsql/data . instead. Otherwise, the /usr/local/pgsql path gets store

21.12. Certificate Authentication, terminology

2022-12-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/auth-cert.html Description: Re: https://www.postgresql.org/docs/current/auth-cert.html and "21.12. Certificate Authentication" "Certificate Authentication" as used in this context is typi

Tablespace with multiple locations

2022-12-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-createtablespace.html Description: Hello, I m kindly requesting a clarification regarding a debatable subject in one of my projects, that if it's possible to create one global tablesp

Tutorial make command comment

2023-01-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-sql-intro.html Description: It would be valuable for someone who only just clones the repo, to mention that before running make to get the tutorial build, ./configure must be run

random-page-cost

2023-01-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/runtime-config-query.html Description: Two comments on random-page-cost parameter here https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-RANDOM-PAGE-COST 1) Adding a

There is no command pg_ctl reload in Postgresql 13 clusters

2023-01-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/config-setting.html Description: Could you provide additional information about pg_ctlcluster command? On postgrsql 13 clusters there is no pg_ctl reload. So we should not use `pg_ctl rel

Postgres Partitions Limitations (5.11.2.3)

2023-01-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/ddl-partitioning.html Description: Link: https://www.postgresql.org/docs/current/ddl-partitioning.html#DDL-PARTITIONING-DECLARATIVE "Using ONLY to add or drop a constraint on only the par

8.5.2 "integral" - "integer"

2023-01-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-datetime.html Description: I think, the "integer" will be good choice instead "integral'": 8.5.2 ... "The offset will be shown as hh (hours only) if it is an integral number of ho

The documentation for storage type 'plain' actually allows single byte header

2023-01-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/index.html Description: https://www.postgresql.org/docs/devel/storage-toast.html - This is the development version. > PLAIN prevents either compression or out-of-line storage; furthermore

Background worker

2023-01-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/bgworker.html Description: Hi Team, The glossary is a really nice summary of what each term means. The background worker gives a nice summary as to what it does "Background worker (proce

Typo in 2.7 Aggregate Functions

2023-01-16 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: Near the end of Chapter 2.7 Aggregate Functions of the documentation, the command FILTER is introduced. The full query is SELECT city, max(temp_lo), count(*

broken link

2023-01-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/index.html Description: The FAQ page https://wiki.postgresql.org/wiki/FAQ has a broken link at the very bottom: "Bruce Momjian's presentation" http://momjian.us/main/presentations/features

Adjustment to pg_stat_statements F.32

2023-01-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/docguide.html Description: The default limit of 5000 statements applied by the pg_stat_statements.max parameter is not mentioned until farther down in the article at F.32.4 . For ease of r

gen_random_uuid is only available with pgcrypto enabled

2023-01-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/functions-uuid.html Description: Regarding the documentation on this page: https://www.postgresql.org/docs/15/functions-uuid.html It think the documentation should state clearly, that pos

https://www.postgresql.org/account/comments/new/15/sql-alterdatabase.html/

2023-01-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-alterdatabase.html Description: Would love to see more information about each of the ALTER DATABASE parameters... a specific... "connlimit"... -1 means no connections, but what does 0

Naming of network_ops vs. inet_ops for SP-GIST

2023-01-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/spgist-builtin-opclasses.html Description: I wanted to add an SP-GIST index for an inet field ip_address In https://www.postgresql.org/docs/14/spgist-builtin-opclasses.html network_ops is

Not an error but a difficult wording

2023-01-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sourcerepo.html Description: https://www.postgresql.org/docs/current/sourcerepo.html I was convinced that there was a missing word or something in "because the files that these tools are

Suggestion for deprecated spellings

2023-01-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-createrole.html Description: From time to time some spelling for given command gets obsolete, yet it is shown in the syntax on "equal rights" as other valid clauses. For instance see `

1.3 Creating a database - windows 10x64

2023-02-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-createdb.html Description: I installed pgsql with binary for windows from official website. Going through the tutorial I found that I have no createdb command and for me to create

documentation clarification of tsvector length limitation

2023-02-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/textsearch-limitations.html Description: I'm suggesting a documentation clarification to the statement "The length of a tsvector (lexemes + positions) must be less than 1 megabyte" from th

Getting out of copy out mode

2023-02-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/protocol-flow.html Description: In copy out mode it is mentioned "Otherwise, any message type other than CopyData or CopyDone may be treated as terminating copy-out mode.". This is confusi

unclear syntax explanation for multiple window definitions in a SELECT query

2023-02-16 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: The syntax documentation for SELECT in SQL COMMANDS section is unclear in explaining how to use multiple window definitions. It's easy to read it and believe

Transaction wraparound and read committed isolation level

2023-02-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/routine-vacuuming.html Description: hey guys thanks for the work you do we really appreciate it. In the transaction wraparound section this statement is misleading and got me really con

MERGE examples not clear

2023-02-21 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: On this page: https://www.postgresql.org/docs/15/sql-merge.html the first and second examples seems to be contrasted (by "this would be exactly equivalent to th

Row Level Security Execution within the SQL Evaluation Pipeline

2023-02-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-createpolicy.html Description: RLS documentation seems to say the user's predicate is evaluated AFTER the policy is evaluated. This presents to me an issue that I can't wrap my head ar

Modifying Arrays

2023-02-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/arrays.html Description: According to the official document of PostgreSQL 15, in the section 8.15.4. Modifying Arrays there is a statement like: The slice syntaxes with omitted lower-boun

incorrect info in dblink examples

2023-02-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/contrib-dblink-function.html Description: In your examples, AS t1(proname name, prosrc text) should actually be AS t1(proname text, prosrc text) This occurs frequently in the

Mistake in statement example

2023-03-01 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: I believe there is a mistake in an example on https://www.postgresql.org/docs/current/transaction-iso.html section 13.2.1: BEGIN; UPDATE accounts SET bala

I think that the transaction tutorial document (3.4) should mention transaction isolation

2023-03-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-transactions.html Description: Hi, I just discovered that by default, transactions are not entirely isolated. I think that the tutorial should mention this. The tutorial gives t

Make SSPI documentation clearer

2023-03-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sspi-auth.html Description: The [current SSPI documentation](https://www.postgresql.org/docs/current/sspi-auth.html) reads: "SSPI authentication only works when both server and client are

bytea documentation error

2023-03-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-binary.html Description: I believe there is a documentation error in the example for "8.4.1 bytea Hex Format" (https://www.postgresql.org/docs/current/datatype-binary.html#id-1.5.

Seeming contradiction in 22.1

2023-03-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: In chapter 22.1 the following text seems to imply the role will have "the same name as the user that initialised" it and also the "role will be named postg

Mistake in documentation (PG15+)

2023-03-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-numeric.html Description: Greetings. Just found a mistake in documentation: https://www.postgresql.org/docs/15/datatype-numeric.html $$ Thus, a column declared as NUMERIC(2, -3)

Misleading "For more information..." placement

2023-03-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-character.html Description: In the paragraph > The characters that can be stored in any of these data types are determined by the database character set, which is selected when

List Tables

2023-03-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-table.html Description: Would be nice to add a paragraph after create table and before delete table with list tables.

Split_Part w/negative integer does not work

2023-03-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/functions-string.html Description: When n is negative, an error occurs. Documentation split_part ( string text, delimiter text, n integer ) → text Splits string at occurrences of delimite

Minor typo in 13.3.5. Advisory Locks

2023-03-28 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: After the code snippet in the 6th paragraph of 13.3.5. Advisory Locks (https://www.postgresql.org/docs/current/explicit-locking.html#ADVISORY-LOCKS) I be

Confusion between psql options and pg_service file config

2023-03-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/libpq-connect.html Description: Hi folks, I feel like I'm going in circles trying to square `psql` options (15: psql) with connection service file parameters (15: 34.17). I've lost exact

Cannot update the generation expression for a generated column / make the limitation explicit

2023-03-31 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: In the many forms of ALTER TABLE, described in https://www.postgresql.org/docs/current/sql-altertable.html, it appears that a generated column, defined wit

Correction: Postgres emum documentation 8.7.4 should read 63 characters (instead of bytes)

2023-04-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-enum.html Description: Postgres documentation, section 8.7.4 gives the limit on enum labels as 63 bytes. Testing this with an oversized string gives the following error: SQL Error

recovery from continuous-archiving

2023-04-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/continuous-archiving.html Description: As of version 14, the server will continue restore from the WAL files. It stops when the last requested file does not exist, which is true since the

Bug in the documentation - to_tsquery( 'postgres:*' );

2023-04-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/index.html Description: There is a bug in the documentation on the link https://www.postgresql.org/docs/current/datatype-textsearch.html postgres does not get stemmed to postgrby :to_

Packaging Related Objects into an Extension

2023-04-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/extend-extensions.html Description: This needs a section on how to remove Extensions. My specific case is I have an old extension with no make file and i have to remove it manually. I h

Information on setting the message level is too hard to find if you search for "debug"

2023-04-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/runtime-config-client.html Description: It took me a good bit of searching to find the page for remembering that client_min_messages was the variable for the debug level. I think my basic

Perhaps an issue on the collation page?

2023-04-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/collation.html Description: This page states: Observe how in the traditional ICU locale naming system, the root locale is selected by an empty string. CREATE COLLATION latinlast (pro

Misleading description for IPC wait events in PostgreSQL documentation

2023-05-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/monitoring-stats.html Description: While preparing for my presentation on PostgreSQL Wait Events at PgConf India, I was trying to understand *IPC:XactGroupUpdate* in more detail. PostgreSQ

Incorrect link tohttps://www.postgresql.org/docs/current/indexes-functional.html ?

2023-05-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/indexes-expressional.html Description: Hi, nice to meet you. I found incorrect link to https://www.postgresql.org/docs/current/indexes-functional.html on this page https://www.postgresql

CREATE TABLE ... PARTITION OF ...

2023-05-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-createtable.html Description: Documentation does not state that CREATE TABLE ... PARTITION OF ... requires an ACCESS EXCLUSIVE lock on the parent table (it only mentions that about DR

pg_basebackup application does not dump all database objects

2023-05-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/app-pgbasebackup.html Description: Hello! It would be good to point out on the pg_basebackup documentation that it behaves differently from SELECT * FROM pg_start_backup('label', true, f

Postgres 14 documentation suggests range_agg is available, but it's not until Postgres 15

2023-05-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-aggregate.html Description: Hello - I noticed that range_agg is listed in the Postgres 14 documentation as an available aggregate function here: https://www.postgresql.org/docs

Incorrect/confusing information about timetz

2023-05-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-datetime.html Description: This statement in section 8.5.3 states "All timezone-aware dates and times are stored internally in UTC. They are converted to local time in the zone sp

DROP INDEX - dropping index of a table in a named schema

2023-05-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-dropindex.html Description: I had to find out (as it is not in the given documentation) that to drop an index for a table in a named schema (later "schemaname.tablename") you have to p

Typo

2023-05-23 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 Folks, thank you for maintaining this great technical resource, which I've only recently started to use. There appears to be a typo, here: https://www.postgre

5.11.1 Table Partitioning Overview - "...the size of the table should exceed the physical memory.."

2023-05-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/ddl-partitioning.html Description: Is this rule of thumb a typo? "The exact point at which a table will benefit from partitioning depends on the application, although a rule of thumb is t

pass open cursor via USING in execute staement

2023-06-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/plpgsql-statements.html Description: Should be documented if this statement is allowed or not (if not, maybe set as desired feature :-) ) EXECUTE format('update %I set col1=$1, col2=now()

pg_class.relpages documentation does not mention relpages corner case

2023-06-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/catalog-pg-class.html Description: In the pg_class documentation [1], the relpages column is described as >Size of the on-disk representation of this table in pages (of size BLCKSZ). This

Pattern matching also includes Full-text search, Trigram and Fuzzysearch

2023-06-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/functions-matching.html Description: Hi, The tip states: "If you have pattern matching needs that go beyond this, consider writing a user-defined function in Perl or Tcl." But there's

Further clarification in documentation: No deletion of unreferenced large objects

2023-06-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/datatype-binary.html Description: When deleting a row that references (contains) a large object, I think that most users expect the DBMS to take care of the, now unreferenced, BLOB. It's g

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

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

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

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

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,

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

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

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

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

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

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

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

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

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 ( ),

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

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

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

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

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

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

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,

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

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

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.

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

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

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

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

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

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

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.

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

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'

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

`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

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

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

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

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

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}

  1   2   3   4   5   6   7   8   9   10   >