Example of creating subscription for publications in the same cluster

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-createsubscription.html Description: This page: https://www.postgresql.org/account/comments/new/10/sql-createsubscription.html/ explains that the CREATE SUBSCRIPTION command would

Improvements regarding explanation of parallel execution and detailed node parameters

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/using-explain.html Description: Proposals for improvement of EXCPLAIN docu https://www.postgresql.org/docs/current/using-explain.html: 1. There is no mentioning of how parallel execution

pg_upgrade "configdir" vs "datadir"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/pgupgrade.html Description: pg_upgrade seems to assume that the datadir and the configdir are the same but on Debian/Ubuntu they are not the same by default (installing from the postgres

any() and ilk wrt to what they accept

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/functions-comparisons.html Description: I recently wanted to do something like "not($col like all($subquery_that_returns_multiple_values))" but wasted quite a bit of time trying to debug

User mapping security

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/postgres-fdw.html Description: Regarding the documentation pages https://www.postgresql.org/docs/10/postgres-fdw.html?origin_team=T02HEPYKQ and

Missing preposition 'of'

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/queries-table-expressions.html Description: By the end of section 7.2.1.5, the preposition 'of' is missing: "(...) we could find out which ones those are like this: (...)" should read

Wrong formatting of the word 'executed'

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-expressions.html Description: In section 43.4, in the sentence "(...) and then this prepared statement is EXECUTEd (...)", the word executed should be modified to lower case.

default_tablespace and parallel queries

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/manage-ag-tablespaces.html Description: Hi, "default_tablespace" parameter in "postgresql.conf" does something to GATHER (in parallel query). Because when default_tablespace is set to

Logical replication restriction documentation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/logical-replication-restrictions.html Description: Re this note in the "logical replication restrictions" documentation page: Replication is only possible from base tables to base tables.

Do not use C++ style comments (// comments). Strict ANSI C compilers do not accept them.

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/source-format.html Description: This sentence in the style guide feels outdated. // style comments have been in the ANSI C standard for almost 20 years now (C99 was accepted as ANSI

invalid ldconfig [option]

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/install-post.html Description: In the line "/sbin/ldconfig -m /usr/local/pgsql/lib" the "-m" is a invalid option. I think is a mispelling of a "-n" option. Best Regards umbo

returning does not act as expected after viewing documentation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/dml-returning.html Description: With the following query: update batch_log set status=('in-progress'), updated_at=now() where status = ('pending') and id = ( select id from batch_log

WITH RECURSIVE (Documentation section 7.8.1) Note

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/queries-with.html Description: In section 7.8.1, the author comments "Note: Strictly speaking, this process is iteration not recursion, but RECURSIVE is the terminology chosen by the SQL

Pls mention ERROR: 2D000: cannot commit while a subtransaction is active on this page

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html Description: Please add a note after this sentence “A transaction cannot be ended inside a block with exception handlers.” (at the bottom of the page) thus: <<

Logical replication conflict and trying to use `pg_replication_origin_advance`

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/logical-replication-conflicts.html Description: I have a pretty detailed setup, and can provide more details if desired, but the real issue is that I am seeing an error like the

typo in 9.15. JSON Functions and Operators Table 9.46. JSON Processing Functions - alternate

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/functions-json.html Description: sorry, the last message may have been incorrect. if so, the next row in table 9.46 should be changed from: jsonb_insert(target jsonb, path

typo in 9.15. JSON Functions and Operators Table 9.46. JSON Processing Functions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/functions-json.html Description: In the 'Function' column of Table 9.46: jsonb_set(target jsonb, path text[], new_value jsonb[, create_missing boolean]) should be

Chapter 43.8. "Transaction Management" fails to state two critical restrictions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html Description: This chapter fails to state: (1) If a PL/pgSQL procedure issues "commit" then it must be called with AUTOCOMMIT set to On. This is

RESET does not work as described

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/bug-reporting.html Description: The initial value returned when current_setting() is passed an unset parameter is ''. After a SET and a RESET, the value returned by current_setting() is

Does TRUNCATE emit changes with REPLICA IDENTITY FULL?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-truncate.html Description: Hi, The documentation says that TRUNCATE ignores ON DELETE triggers, but it doesn't explicitly mention what happens if we use `wal_level = logical` and

Adding a Column documentation is misleading

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-alter.html Description: In 5.6.1. Adding a Column, there is a kind of example 'ALTER TABLE products ADD COLUMN description text;' The words 'description' and 'text' are misleading --

Nit: "Immutable" should be "pure"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-createindex.html Description: The adjective "immutable" describing the functions and operators used in an index (see two occurrences in doc snippet below) is incorrect and should be

The word "virgin" used incorrectly and probably better off replaced

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/manage-ag-templatedbs.html Description: The use of the word virgin as an adjective is incorrect here and also an anachronism. It is better off replaced with the word pristine - quotes

tables in the DB is not available after pg_restore.

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/app-pgrestore.html Description: Hi, I have one question about pg_restore tool, tables in the DB is not available after pg_restore. Even if the user is still the owner of table after

20.3. Authentication Methods for PostgreSQL 11 not present

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/auth-methods.html Description: In section 20.3 of PostgreSQL 11, the documentation is lacking the same amount of content as in section 20.3 of other versions of PostgreSQL. All

no mention of GRANT USAGE in postgres_fdw docs

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/postgres-fdw.html Description: The documentation page for postgres_fdw gives a nice step by step on what's needed to configure

COPY FROM needs better example

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-copy.html Description: The example shown for COPY FROM is very basic and doesn't show how to use any of the options -- which have tricky syntax that seems to trip up a number of

Make default values bold in Synopsis / bnf diagram

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-set-transaction.html Description: As an example let's take take "BEGIN" in the Synopsis : Start Synopsis for BEGIN BEGIN [ WORK | TRANSACTION ] [

pg_basebackup page need further clarification

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/app-pgbasebackup.html Description: Hi! At first I want to thank your for this wonderful software! I'm reading pg_basebackup page now and don't see two important section: 1) Restoring

Serializable description seems misleading?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/transaction-iso.html Description: Let's say I have two transactions running in Serializable isolation: T1: Reads a row T2: Reads the same row T1: Updates the row T1: Commits T2: Commits

Example for unnest(anyarray, anyarray) fails

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/functions-array.html Description: ~ $ psql psql (11.2, server 9.6.14) Type "help" for help. ghowe=# select version(); version

Difference between Bulk Load (Multiple inserts or single inserts) and COPY

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-copy.html Description: Hello, > I experimented with Bulk load and COPY. > Loading in COPY was very fast. > However, after COPYing data from a CSV file to PostgreSQL Table. The query

Description of Authentication Methods Supported for Map is Misleading

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/auth-pg-hba-conf.html Description: "This option is supported for all authentication methods that receive external user names." More properly, the authentication methods supported are:

It is recommended to add detailed description about initdb ...

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/creating-cluster.html Description: When I run initdb -D /home/myname/pgsql/data in /home/myname/pgsql/bin, it return bash: initdb: command not found The others are like this. It must

Re: Example 42.4. A PL/pgSQL Trigger Function for Auditing

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/plpgsql-trigger.html Description: I'm wondering if it would be worthwhile to put a totally generic auditing function into the documentation e.g. CREATE OR REPLACE FUNCTION zz_audit_()

wal_sender_timeout / wal_receiver_timeout - seconds or milliseconds?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-replication.html Description: Dear sir or madam! The documentation about the parameter wal_sender_timeout refers to an integer value in milliseconds in the first sentence.

doc correction

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-generated-columns.html Description: https://www.postgresql.org/docs/12/ddl-generated-columns.html In the below "Consider the differences between a column with a default and a

JSON: @@-operator

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-json.html Description: '{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2' does not work; '{"a":[1,2,3,4,5]}'::jsonb @@ '$.a[*] > 2'::jsonpath works as expected

Correction For PostgreSQL Manual

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/bgworker.html Description: The warning about background worker processes at the beginning of Chapter 47 reads: Administrators wishing to enable modules that include background worker

Duplicating Records When Inserting

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/release-11-5.html Description: Hello, when starting to use postgres version 11.5, there are duplicate records, what can it be? I have always used 9.6 and never had this problem. I'm

39.2. Event Trigger Firing Matrix - add note

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/event-trigger-matrix.html Description: 39.2. Event Trigger Firing Matrix - add note to ALTER TABLE tag "see section 39.1. " This section contains text "The sql_drop event occurs just

monitoring-stats.html is too impenetrable

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/monitoring-stats.html Description: There needs to be a tutorial page explaining how to use pg_stat_all_tables to find missing indexes, or maybe just an example on monitoring-stats.html

COPY manual is ambiguous about column list

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-copy.html Description: "If a list of columns is specified, COPY will only copy the data in the specified columns to or from the file. If there are any columns in the table that are

Example not producing shown output

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-textsearch.html Description: Page: https://www.postgresql.org/docs/12/functions-textsearch.html Examples should have specified 'english'. Instead: to_tsvector('fat cats ate

auto_explain.log_min_duration is limit for nested statement

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/auto-explain.html Description: Hello, I had problem with setup auto_explain.log_min_duration for COPY command on table with triggers. I set minimum duration to '2s' but no plan logged

documentation clarifications for "alter sequence" ?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-altersequence.html Description: postgresql 11.5 I execute this: CREATE TABLE v5processing.just_testing( id SERIAL, some_test text ); -- sequence last value is now 0, min

Difference between Bulk Load (Multiple inserts or single inserts) and COPY

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-copy.html Description: Hello, > I experimented with Bulk load and COPY. > Loading in COPY was very fast. > However, after COPYing data from a CSV file to PostgreSQL Table. The query

I'm surprised to see the word master here

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/logical-replication-publication.html Description: I was under the impression we were removing the use of that word from our docs ?

Document: https://www.postgresql.org/docs/current/tutorial-sql-intro.html

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-sql-intro.html Description: This references src/tutorial and basics.sql. Neither are available in Windows 10 install for Postgres 12.

Typo on Refresh Materialized View page

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-refreshmaterializedview.html Description: Hello There appears to be a typo on this page: https://www.postgresql.org/docs/12/sql-refreshmaterializedview.html In the description of

grammar mistake in java8-date-time.html ?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/bug-reporting.html Description: I think that there's a grammar error in the following doc url: https://jdbc.postgresql.org/documentation/head/java8-date-time.html It says: "Also note

Invalid website links

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/gin-intro.html Description: Chapter 66.1: "The GIN implementation in PostgreSQL is primarily maintained by Teodor Sigaev and Oleg Bartunov. There is more information about GIN on their

A Rant on lock_timeout

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-client.html Description: Hello, I was looking explicitly for information on the default value of lock_timeout and what it does. I got this paragraph: "Abort any statement

pg error question

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/errcodes-appendix.html Description: when we use pgsql a error happens ERROR: XX000: unrecognized node type: 68

Where is libpq_fe.h

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/libpq.html Description: When building an app or library that links with libpq.dll it is obviously necessary to include libpq_fe.h. The documentation recommends using binary distributions

Default user 'postgres' not mentioned in the documentation?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/postgres-user.html Description: Hi I'm a newbie and may be asking stupid questions... but shouldn't it be mentioned in the official documentation on this page

COPY performance vs insert

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/populate.html Description: I think this could be clearer. In particular, performance of COPY vs INSERT from a query (INSERT INTO ... SELECT FROM ...) or INSERT with a list of rows (INSERT

ALTER TABLE syntax incomplete

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-altertable.html Description: I believe the documentation page https://www.postgresql.org/docs/11/sql-altertable.html is missing the action ADD CONSTRAINT, as it is mentioned in the

Possible typos in the #12.1.1 examples

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/textsearch-intro.html Description: SELECT title || ' ' || author || ' ' || abstract || ' ' || body AS document FROM messages WHERE mid = 12; Seems like here the example missed 'm' as

Minor error

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/indexes-partial.html Description: A sentence on this page reads: "The system can recognize simple inequality implications, for example “x < 1” implies “x < 2”; otherwise the predicate

reassign owned requirement of locks

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-reassign-owned.html Description: reassign owned document didn't say its requirements of locks

thoroughly broken examples on the Dynamic SQL page

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/ecpg-dynamic.html Description: Has anyone tried the examples on the https://www.postgresql.org/docs/11/ecpg-dynamic.html Dynamic SQL page? The very first line in each example immediately

explanation for random_page_cost is outdated

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-query.html Description: Explanation for random_page_cost is rather outdated, because it did only for case of mechanical hdd. But all modern database servers, which I know,

Missing File weather.txt

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-populate.html Description: On this page https://www.postgresql.org/docs/12/tutorial-populate.html you have this command: COPY weather FROM '/home/user/weather.txt'; I've

pg_dump documentation page

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/app-pgdump.html Description: Hi, I'm not certain but I think that on the page: https://www.postgresql.org/docs/9.6/app-pgdump.html, it should mention that to use the -j (jobs) switch,

Incomplete or misleading explanation of the data types for mathematical operators

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-math.html Description: "The bitwise operators work only on integral data types, whereas the others are available for all numeric data types. " Many math operators silently

RETURNING does not explain evaluation context for subqueries

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/dml-returning.html Description: In the docs explaining RETURNING https://www.postgresql.org/docs/11/dml-returning.html there is no mention of the fact that a nested sub-select in the

Examples required in || 5.10. Table Partitioning

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-partitioning.html Description: Hello , As I'm searching for the official documentation of Hash Partition and List Partition with example with more description the only information is

pg_dump, --exclude-table-data

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/app-pgdump.html Description: I cannot find and understand what happens, if I will ommit the table data for a table where primary keys are refenced by foreignkeys from other tables. I

Exsamples for COPY

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-copy.html Description: It would be benefitial to add some more complex (real-life) exsamples to new syntax Eg: Reading TAB-delimited UTF8 CSV file residing in local machine and

Users/Roles do not align.

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-schemas.html Description: According to Section 5.9. Schemas: https://www.postgresql.org/docs/12/ddl-schemas.html `A PostgreSQL database cluster contains one or more named databases.

btree index maximum row size

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/limits.html Description: Appendix K (PostgreSQL Limits) - doesn't mention the (btree) index row size limits. I think that it should.

Move description of general lock behaviour out of the "13.3.1. Table-level Locks section"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/explicit-locking.html Description: Hi The "13.3.1. Table-level Locks" subsection mentions the following: "Once acquired, a lock is normally held till end of transaction." (maybe we

documentation extension request - order with function over aggregated functions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/queries-order.html Description: In https://www.postgresql.org/docs/9.5/queries-order.html it is said that the following is intentionally not allowed: ``` SELECT a + b AS sum, c FROM

Keyword BYTEA missing from Documentation Appendix C

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-keywords-appendix.html Description: https://www.postgresql.org/docs/12/sql-keywords-appendix.html BYTEA missing from Keyword list. Is this intentional? Thanks, NU

create extension requires superuser?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-createextension.html Description: https://www.postgresql.org/docs/10/sql-createextension.html "For most extensions this means superuser or database owner privileges are needed" (this

Lack of detailed documentation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-geometry.html Description: On: https://www.postgresql.org/docs/current/functions-geometry.html The functions aren't defined, nor have pointers. For instance: *

9.4. String Functions and Operators page does not document that encode adds line breaks

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-string.html Description: It took me a long time to discover why a base 64 encoded SHA-512 hash was 89 characters long instead of the expected 88. The documentation does not

Typo

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/libpq-ssl.html Description: On page https://www.postgresql.org/docs/11/libpq-ssl.html in phrase "if no Subject Alternative Name of type dNSName is present." dNSName should be DNSName

Wrong insert before trigger examples

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-partitioning.html Description: Hi, I just noticed that the example in 5.11.3.1. Point 5 contains an "before insert trigger" which will not work anymore (I think since Postgres 12).

Clarification on interactions between query parameters and partial indexes

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/indexes-partial.html Description: In section "11.8 Partial Indexes" it states the following: "Matching takes place at query planning time, not at run time. As a result, parameterized

the date() function is undocumented while quite necessary

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-datetime.html Description: I can't find anywhere the documentation of the SQL DATE() function which extracts the date part out of a timestamp. Please note that according to my

pg_buffercache query example results misleading, grouping by just relname, needs schema_name

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/pgbuffercache.html Description: The pg_buffercache query example results are misleading. The "group by" uses just by relname. It needs to include pg_namespace.nspname, without it, if the

role creation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/role-attributes.html Description: The reference for `CREATE ROLE` has the following text in the `NOTES` section regarding the `CREATEROLE` privilege: >Be careful with the CREATEROLE

LOGIN/NOLOGIN in psql

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createrole.html Description: Please add something like this to the LOGIN/NOLOGIN part: The `psql` commands `\du` and `\dg` show `Cannot login` for roles with `NOLOGIN` and nothing

Suggestion on Document for Version 12 Section 40.3

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/rules-materializedviews.html Description: Hello all, I'm reading Section 40.3, and there is an example (the third square by reverse order): SELECT word FROM words ORDER BY word <->

Correct: Typo in Documentation for Version 10&12 Section 40.3

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/rules-materializedviews.html Description: Hi, This a follow-up email with the last one I sent. I wrongly put the link to version 10, but the typo still exists in version 12 as here

Typo in Documentation for Version 12 Section 40.3

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/rules-materializedviews.html Description: Hi all, This is the link to the page which has a typo. https://www.postgresql.org/docs/10/rules-materializedviews.html. In the line below the

Postgres.js driver - for Node.js

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/external-interfaces.html Description: Hi. I recently finished a fast, 0 dependency driver for Node.js with a very user friendly api. I think would be great to include in the

SE-Linux mispelled

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-security-label.html Description: Should be SELinux instead of SE-Linux. This is the only page that has the typo: https://www.postgresql.org/docs/12/sql-security-label.html

IS_SUPERUSER

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-show.html Description: I think it would be helpful on the manual page for SHOW to note that SHOW ALL does _not_ show the value of IS_SUPERUSER.

Put cluster in the hierarchy in 22.1

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/manage-ag-overview.html Description: 22.1 says "So the full hierarchy is: server, database, schema, table (or some other kind of object, such as a function)." Could "cluster" be added in

the concept of a database cluster

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/creating-cluster.html Description: In 18.2, a database cluster is said to be "a database storage area on disk", and then shortly afterward is is defined as "a collection of databases that

Argument 'week' not supported in date_trunc function with intervals

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-datetime.html Description: In the documentation of the date_trunc function (9.9.2), the first argument (field) cannot be 'week' if the second argument (source) is an interval:

Transaction Management requires Autocommit

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html Description: It's worth mentioning that "Transaction Management" requires "Autocommit" to be ON. Otherwise you get an error.

Spanish translation of postgresql manuals

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/index.html Description: I am translating the Postgresql 10.11 manual into Spanish. Yes, someone is interested in this, to contact me. Thank you.

pg_ctl in Windows

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/app-pg-ctl.html Description: Could it be added that in Windows pg_ctl needs to be run as administrator? I spent a lot of time trying to figure out why the program didn't run, before I

doc: Add anchors in create_table.sgml

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-createtable.html Description: From 73ad66d721a3f87500857cdc6b1f4d810f2875df Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Ivan=20Mas=C3=A1r?= Date: Thu, 2 Jan 2020 09:15:34 +0100 Subject:

Concurrency

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/mvcc-caveats.html Description: add some Query example to learn easy and add some practice example that will help to understand it cleary. Thankyou

Documentation: 21.5. Default Roles

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/default-roles.html Description: The title is wrong. The roles are not defaults; they are predefined and privileged. The title suggests that a user should expect to be assigned these

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