Proposal to improve the content in subsection 8.16.6. "Composite Type Input and Output Syntax"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/rowtypes.html Description: 1. Replace this: "...the whitespace will be ignored if the field type is integer, but not if it is text." with this: "...the whitespace will be ignored if the

terminology in example

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-inherit.html Description: In the example on this page: https://www.postgresql.org/docs/current/ddl-inherit.html the word 'altitude' should be replaced with 'elevation'.

Incorrect dropuser command in postgress 11

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/app-dropuser.html Description: The command given in documentation for dropping a postgres user is 'dropuser ' . It should be 'drop user '. The previous one gives syntax error

68.2.1

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/storage-toast.html Description: ALTER TABLE ... SET (toast_tuple_target = N) is not documented in "ALTER TABLE" SQL commands section.

optionally schema-qualified for table_name

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-altersequence.html Description: Although I can see that table_name in OWNED BY clause can be optionally schema-qualified by ᅟcarefully reading "The specified table must have the same o

37.10.3

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/xfunc-c.html Description: There is mention to macro PG_ARGNULL_xxx() which I cannot locate. Aren't you talking of PG_ARGISNULL(n) ?

Inherited tables cannot be partitioned (version 12.0)

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-inherit.html Description: In the document pages for Inheritance and partitions, it could be worth mentioning that an inherited table cannot be partitioned. I tried to apply a 2 levels

invalid parser name

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/textsearch-parsers.html Description: Page https://www.postgresql.org/docs/9.6/textsearch-parsers.html (other versions are affected as well). The document says "The built-in parser is nam

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

Error in docs

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/explicit-locking.html Description: https://www.postgresql.org/docs/12/explicit-locking.html In the block after this sentence: "This acquires a row-level lock on the row with the specifie

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 an

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 des

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 cond

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 t

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

Information regarding how to build libpq client using visual studio is missing

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/libpq-build.html Description: Current(12.2) documentation does not have information regarding how to build libpq client using visual studio is missing.It would be great help if this is spe

REGEXP_REPLACE : How to use a column value in the regex

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-matching.html Description: The documentation doesn't talk about any regex syntax for using a column from the db in the pattern. There is no mention if this is NOT supported. All

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 t

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 quer

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 priv

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 for

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 s

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

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 menti

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 i

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: * Scaling/r

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

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

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 RETUR

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). Th

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 tabl

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 shoul

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

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 Postrg

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 think

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

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 conver

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

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 searche

not clear what it means

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/performance-tips.html Description: Hi, here: https://www.postgresql.org/download/products/6-postgresql-extensions/ In section about: pg_track_settings look for: that me must called I'm not

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 fou

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

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 https

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 documentatio

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

Multiple window definitions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-select.html Description: According to the spec: [ WINDOW window_name AS ( window_definition ) [, ...] ] So the ... means I can have more than one named window. But I can't make this

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

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 t

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

glossary

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/creating-cluster.html Description: It would be great to have a glossary as an appendix, to define concepts such as cluster, schema, tablespace, database.

PostgreSQL in Windows

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/postgres-user.html Description: There are multiple places in the manual that are seem written primarily for UNIX environments. It is sometimes unclear how the manual section applies in a W

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.

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:

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 foun

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.

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.

is_nullable column of information_schema.columns table

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/infoschema-columns.html Description: is_nullable column of information_schema.columns table does not show correct values for columns of views. For tables that column shows correct values w

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 ro

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

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 https://www.postgresql.org/

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_() RET

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

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 Y

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 backu

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 b

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

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 >

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 ] [ transac

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 not

legacy assumptions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/datatype-json.html Description: I'm wondering if this one line of section 8.14 JSON Types (https://www.postgresql.org/docs/current/datatype-json.html) can be edited to remove the word "leg

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

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 wh

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 >

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 valu

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 people

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 befor

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, Myself Mayank. I am a Ph.D. student. I experimented with Bulk load and COPY. Loading in COPY was very fast. However, after COPYing data from a CSV fil

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 a

Regarding Foreign data wrapper Import Schema

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-importforeignschema.html Description: Need little more clarification about OPTIONS ( option 'value' [, ...] ) on Import schema feature. Like while importing i need to rename table as f

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

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 rest

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 re

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 unne

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

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

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 information

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

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 generate

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 confus

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 proc

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.

Log Rotation Documentation Update

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-logging.html Description: Hi all: We recently ran into an unusual case where the following occurred: - PG log directory is a separate filesystem from PG data and other oper

FATAL: password authentication failed for user "postgres

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/index.html Description: Everytime i use postgres to login, it fails to login . even though if user id and password is the default one.

PostgreSQL 12 release notes missing breaking change in libpq

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/release-12.html Description: Hi! In PostgreSQL 12, libpq's parsing of connection string integer parameters was made more strict, such that invalid values now result in an error rather tha

Table 9-40. json and jsonb Operators - Data could be more informative

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/functions-json.html Description: In https://www.postgresql.org/docs/9.4/functions-json.html, the table 9.40, json and jsonb operators lists '->>' and '#>>' operators and the difference

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 o

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

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 CON

<    3   4   5   6   7   8   9   10   11   12   >