Incorrect Syntax in Function Syntax diagram

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createfunction.html Description: | IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF [ NOT ] LEAKPROOF is accepting separately , So why you written [ NOT ] LEAKPROOF with | IMMUTABLE

Document behaviour of failed sub queries

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-subquery.html Description: I have found that when a sub query fails, the preceeding IN will ignore the failure and execute as if the subquery did not exist. I think this should

SETOF specification and default behavior (CREATE FUNCTION)

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createfunction.html Description: It seems like an oversight that the synopsis for CREATE FUNCTION doesn't actually show the modifier "SETOF" as a optional literal part of the syntax bu

docs issue in transactions section

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: 13.2.1. Read Committed Isolation Level Read Committed is the default isolation level in PostgreSQL. When a transaction uses this isolation level, a SELECT

ECPG cursor examples should include EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while loop

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ecpg-variables.html Description: Without this line: EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while(1), I find that ECPG CURSOR examples fail. For example, this example under 36.4.4

Second-granular timezone offset format not documented

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-formatting.html Description: I would like to request additional documentation on the timezone format that can be returned. Context: I had a problem with the HDBC-postgresql libra

markdown error

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-json.html Description: Tables for operators and functions in version 13 and devel 14 are broken https://www.postgresql.org/docs/current/functions-json.html

Manua correction

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-string.html Description: Hopefully the referrer page was kept. I'm referring to the string functions page that reads... == position ( substring text IN string text ) → integer R

NOT DEFERRABLE constraints are checked before command finishes

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtable.html Description: According to the docs: A constraint that is not deferrable will be checked immediately after every command. But this is the behavior I observe on PG 13.

getting table name from partition

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-partitioning.html Description: I would like to add a sentence like this into the description of partitions: You receive the name of the partition table data is from using tableoid::re

ddl-basics.html plural stuff

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-basics.html Description: Probably this is horribly pedantic but 'data' is a plural word and database people should of all humans know this. Datum is the singular. Should 'this many col

user-defined function in Perl or Tcl ???

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-matching.html Description: https://www.postgresql.org/docs/current/functions-matching.html > If you have pattern matching needs that go beyond this, consider writing a user-defi

Exponentiation example not clear

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-math.html Description: Quoting the docs: Exponentiation (unlike typical mathematical practice, multiple uses of ^ will associate left to right) 2 ^ 3 → 8 2 ^ 3 ^ 3 → 512 You co

Another pg_dump using split and gzip for large databases

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/backup-dump.html Description: pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz'

Headers for each index

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/indexes-types.html Description: For easier visual navigation could you please add headers or color the different types of indexes? At the moment, one needs to read the whole document or do

/usr/local/pgsql Location on Manjaro/Arch

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/backup-file.html Description: I'm running an up-to-date version of Manjaro Linux (510 kernel), and following this guide I wasn't able to find my database files in /usr/local/pgsql/data, bu

Common case not at all clear

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: For all this documentation, it is completely unclear how to handle the most common, simple case. I.e. Select balance into :bal ...where key =123; Updat

documentation describing the range of a number type 'integer' is incorrect

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-numeric.html Description: https://www.postgresql.org/docs/13/datatype-numeric.html says that the range of a numeric type integer is -2147483648 to +2147483647 but PGTYPESnumeric_t

psql's commit df9f599b is not documented

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/app-psql.html Description: Hi quit and exit commands have been added to psql starting from psql 11 through this commit df9f599b https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit

create global table

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-createtable.html Description: Hi, I love your project and currently live alongside it. Merely commenting that it is unclear to me what do GLOBAL/LOCAL mean if the table is not TEMP. G

create global table - invalidate previous comment

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-createtable.html Description: From the syntax on "create table" , I've understood that global/local may be used only for TEMP tables, so my previous report is incorrect. Sorry.

vacuum_cost_page_miss (integer) -> read from disk or from outside of the shared buffers?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/runtime-config-resource.html Description: hi, i am not sure if definition of vacuum_cost_page_miss paraemter on https://www.postgresql.org/docs/current/runtime-config-resource.html is corr

incorrect information in documentation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/row-estimation-examples.html Description: Hello, on page https://www.postgresql.org/docs/current/row-estimation-examples.html - there is a example: selectivity = (1 - null_frac1) * (1 - nu

Potential vuln in example for "F.25.1.1. digest()"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/pgcrypto.html Description: Hi, in "F.25.1.1. digest()" you suggest: CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$ SELECT encode(digest($1, 'sha1'), 'hex') $$ LANGUAGE SQL

Unclear\mistakable description of UPDATE behaviour in "13.2.1. Read Committed Isolation Level"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: hello! documentation for "read committed" says that: "UPDATE, DELETE, SELECT FOR UPDATE, and SELECT FOR SHARE commands ... ...If the first updater commi

refresh concurrently: limitation of diff refreshing

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-refreshmaterializedview.html Description: Hi, it may seem obvious, but it took us TB of WALs and some time to identify the problem, why a bigger materialized view created much more WA

I came here to determine how much storage a boolean variable uses

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype.html Description: I'd like to see a fourth column added to Table 8-1 that contains the size or size range of the data type. Maybe a note about the amount of space in the row that

Error in sql script

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/textsearch-configuration.html Description: In /13/textsearch-configuration.html, the last script block starts with some incorrect characters and we do not see the sql command to list the T

Simple re-wording

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/bug-reporting.html Description: "Before you report a bug, please read and re-read the documentation to verify that you can really do whatever it is you are trying." => "Before you report

Keyword docs missing, or mislabelled keywords

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-keywords-appendix.html Description: https://www.postgresql.org/docs/13/sql-keywords-appendix.html Missing: BUFFERS (as found in EXPLAIN) COSTS (as found in EXPLAIN) MODULUS (as found

create rule

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/rules-views.html Description: Nowhere in the documentation is mentioned that rules can only be made on tables without dropped columns and, much to my suprise, on empty tables only. I wante

Warn against transaction level advisory locks for emulating "flat file" DBMS locking strategies

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/explicit-locking.html Description: The docs mention "For example, a common use of advisory locks is to emulate pessimistic locking strategies typical of so-called “flat file” data manageme

13 25.1.1 clarify "The dumps produced by pg_dump are relative to template0"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/backup-dump.html Description: In doc version 13 section 25.1.1 it reads, "The dumps produced by pg_dump are relative to template0. This means that any languages, procedures, etc. added vi

vacuum_freeze_min_age description validity

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/routine-vacuuming.html Description: Hi All, I have a doubt about the vacuum_freeze_min_age explanation here; https://www.postgresql.org/docs/10/routine-vacuuming.html "vacuum_freeze_min_ag

Typos in 34.3.9. Truncating a Large Object

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/lo-interfaces.html Description: The first parameter for both lo_truncate and lo_truncate64 is missing an "N", it says "PGcon *conn", but should be "PGconn *conn".

Default include_dir behaviour

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/config-setting.html Description: Dear postgres-team, please consider adding a short line which clarifies what the default behaviour of the `include_dir` paramter is if it is not set. I am

The huge_pages parameter doesn't work when shared_memory_type is sysv

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/kernel-resources.html Description: It seems that the huge_pages parameter is ignored when shared_memory_type is sysv. The server successfully starts with huge_pages=on, but actually doesn'

Rolinherit- Role automatically inherits privileges of roles it is a member of

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/view-pg-roles.html Description: Roles do not inherit the rolconfig, please see the below labs, postgres=> grant test_audit_app_role to test_app ; GRANT ROLE postgres=> postgres=> selec

GiST indexes appear no longer rely on the first column

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/indexes-multicolumn.html Description: This statement under the GiST index: "the condition on the first column is the most important one for determining how much of the index needs to be sc

Number of GiST support functions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/gist-extensibility.html Description: The documentation states that > There are five methods that an index operator class for GiST must provide, and five that are optional. although ther

clarification on chaining of set operations

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/queries-union.html Description: Apologies if this has been raised previously - I searched the archives and did not find anything. Regarding section 7.4 of the documentation. I was curiou

Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/kernel-resources.html Description: Hi. On https://www.postgresql.org/docs/12/kernel-resources.html, the command to calculate memory allocated to postgres is not correct. Following is the

9.17. Sequence Manipulation Functions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-sequence.html Description: Just a slip of the pen in the table "Function Description", in tha string: "setval ( regclass, bigint [, boolean ] ) → bigint", i think that something

Remove unary operator documentation https://www.postgresql.org/docs/current/datatype-oid.html

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-oid.html Description: On page https://www.postgresql.org/docs/current/datatype-oid.html, for regoperator the example "-(NONE,​integer)" is mentioned. Do I understand correctly tha

Analyze on Foreign Data Wrappers - clarification

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-analyze.html Description: Foreign tables are analyzed only when explicitly selected. Nothing wrong just maybe my newness to PG. I don't understand what "selected" means here: 1.

postgres_fdw installation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/postgres-fdw.html Description: 1. Install the postgres_fdw extension using CREATE EXTENSION. Doesn't actually work or is a bit light on detail, some info on how to install the extension o

pmap grep zero fail to load vm_peak

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/kernel-resources.html Description: pmap 4170 | awk '/rw-s/ && /zero/ {print $2}' is not working if I Do pmap 4170 | awk '/rw-s/ && /zero/ {print $2}' I get 2ac0 1099776K rw

max_sync_workers_per_subscription

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/logical-replication-config.html Description: max_sync_workers_per_subscription option is not added.

information_schema.tables table broken in versions 13+

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/infoschema-tables.html Description: The table on information_schema.tables documentation page is broken after version 12. Instead of three columns in header and body all text is packed ins

Opclass name

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/spgist-builtin-opclasses.html Description: In commit 7a1cd526 (doc: Rework tables for built-in operator classes of index AMs) the name of the inet_ops opclass was changed to network_ops. I

Update documentation page for translators

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/nls-translator.html Description: In the documentation for translators (https://www.postgresql.org/docs/11/nls-translator.html) it is mentioned to use any text editor for translating .po fi

nicer examples for aggregate calls

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-agg.html Description: currently, all of the examples are very simple, like SELECT city, max(temp_lo) FROM weather WHERE city LIKE 'S%'-- (1) GROUP BY city

Comment about not being able to run ANALYZE on replicas

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-analyze.html Description: https://www.postgresql.org/docs/12/sql-analyze.html does not have anything about not being able to run ANALYZE on replicas. I now understand that this is bec

Empty values of pg_stats_ext when table is empty

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/view-pg-stats-ext.html Description: When table mytable is being inherited it may not contain any data but still return row sets from the inheriting tables. Now doing CREATE STATISTICS on m

initdb: nothing about template0

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/app-initdb.html Description: Is it correct that this page does not contain information about the template0 database. The same goes for the "Create Database Cluster" page (https://www.postg

ldapbindpasswd parameter value encrypted

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/auth-ldap.html Description: Hello team, may you please explain if there is a way to store in pg_hba.conf file the value of parameter ldapbindpasswd crypted in some way? Thanks

text fields and performance for ETL

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/datatype-character.html Description: Text field is a field that is intended for very big texts. Performance within Postgres database is commented to be the same as for normal varchar.

Add link to unicode collation docs

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/collation.html Description: This page should include a link to the Collation docs for the Unicode Locale Data Markup Language (LDML). http://www.unicode.org/reports/tr35/tr35-collation.ht

Array functions, array_length behavior given an empty array

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-array.html Description: For whom it may concern, I'd like to propose an extension for `array_length` function description. Currently, it does not cover the case of an empty arr

\dp privileges "decoder" dropped in v12 of docs

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-grant.html Description: Hello, I'm wondering why this version of the GRANT doc has the \dp privilege definitions - https://www.postgresql.org/docs/9.3/sql-grant.html - but it's no long

Ltree pattern matching

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ltree.html Description: In v12 ltree doc (I've not checked other versions) "The behavior of % is a bit complicated. It tries to match words rather than the entire label. For example foo_ba

Example of json_array_elements

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-json.html Description: Maybe this example for json_array_elements is wrong? select * from json_array_elements('[1,true, [2,false]]') It seems to me that it should be select *

Error in sample on doc page

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-event-triggers.html Description: https://www.postgresql.org/docs/13/functions-event-triggers.html Two issues here: 1) The CREATE EVENT TRIGGER command in the sample code does n

"actual time" in QUERY PLAN for parallel operation when loops is bigger than 1

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/using-explain.html Description: https://www.postgresql.org/docs/14/using-explain.html The doc says "the loops value reports the total number of executions of the node, and the actual time

Explicit or implicit?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/textsearch-intro.html Description: https://www.postgresql.org/docs/13/textsearch-intro.html "The @@ operator also supports text input, allowing explicit conversion of a text string to tsv

Triggers on underlying tables of updatable views

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createview.html Description: Hi all, I'm using an updatable view with an underlying table. The underlying table has a trigger attached to it that performs a select statement on the un

max_slot_wal_keep_size unit is not specified

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/runtime-config-replication.html Description: The unit (I assume it's MB) of max_slot_wal_keep_size is not explicitly specified in the docs. If it's intentional then please, disregards, but

More explanation on comparison

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/postgres-fdw.html Description: In the following doc: https://www.postgresql.org/docs/current/postgres-fdw.html it is mentioned that "postgres_fdw provides more transparent and standards-

operator @@ is not supported by path; doc says otherwise

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-geometry.html Description: Hello, The documentation for 13 and 14 says in "Geometric Functions and Operators": > @@ geometric_type → point > Computes the center point. Availabl

set time zone

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-set.html Description: Documentation for the set time zone command can be clearer. What it says for v13: TIME ZONE SET TIME ZONE value is an alias for SET timezone TO value. The syntax

Incorrect source directory in build instructions and build scripts

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/install-windows-full.html Description: I recently downloaded the source for PG 14, and attempted to build for windows using the instructions on this page: https://www.postgresql.org/docs/c

Need more elaborate explanation regarding transactions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-do.html Description: https://www.postgresql.org/docs/11/sql-do.html Says that "If DO is executed in a transaction block, then the procedure code cannot execute transaction control sta

11.7. Indexes on Expressions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/indexes-expressional.html Description: Regarding the paragraph (_emphasis_ added): > Index expressions are relatively expensive to maintain, because the derived expression(s) must be comp

One of the example queries that 'could' is identical to one that 'could not'.

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/indexes-index-only-scans.html Description: 11.9.2 lists ```SELECT x FROM tab WHERE x = 'key' AND z < 42;``` as both examples of 'could' and 'could not' use index-only scans. I believe this

The pg_stop_backup will return one row with three values.

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/continuous-archiving.html Description: It appears that this may be out of date. pg_stop_backup --- (0/2000138,"STA

Unnest discards rows with empty or null arrays

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-srf.html Description: https://www.postgresql.org/message-id/17340-74d17bbe94cb4190%40postgresql.org This behaviour is unexpected from an external perspective but after speaking

include_dir - 'if_exists' logic yes or no?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/config-setting.html Description: include_dir 'directory' it it not 100% clear whether the include_dir option also allows 'if_exists' funtionality. I think a include_dir_if_exists should

^@ operator for text

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-string.html Description: In the new documentation https://www.postgresql.org/docs/14/functions-string.html you again lost information about ^@ operator for text and keep informa

Typo in "27.2.8. Synchronous Replication"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/warm-standby.html Description: The following sentence: > The minimum wait time is the round-trip time **between primary to standby.** Should either end with "...between primary AND stand

vectorization is not helping with plural to singular matching

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/textsearch-intro.html Description: SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); This is giving false, even I tried for various other examples for plural to sin

Add TypeScript driver

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/external-interfaces.html Description: Hi. I am Eray Hanoglu, author of postgresql-client javascript driver written in TypeScript (https://www.npmjs.com/package/postgresql-client). It is an

role_table_grants only shows grantees that are "groups"?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/infoschema-role-table-grants.html Description: It seems like the "grantee" column in this table is only ever a "group", not just roles in general as the documentation seems to say. I know

pg_isready docs doesn't specify what exactly it is checking

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/app-pg-isready.html Description: `pg_isready` docs don't specify how its different from a port probe - what does on top of checking that a port is open? Does it send some handshake message

.pg_service.conf default location and default name on MS Windows platform

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/libpq-pgservice.html Description: Can you please add note about file ".pg_service.conf" default location and default name on MS Windows platform? Why? Accoring to my experience the default

Why can NUMERIC columns not use deduplication?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/btree-implementation.html Description: "64.4.3. Deduplication" says: "numeric cannot use deduplication. Numeric display scale must be preserved among equal datums." However I don't under

CREATE INDEX USING documentation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createindex.html Description: In the CREATE INDEX synopsis(https://www.postgresql.org/docs/current/sql-createindex.html), the USING method parameter is listed, however in the PARAMETER

missing a white space in the last sentence of 51.6. Executor

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/executor.html Description: The last sentence of 51.6. Executor appears: "...feeding that up toModifyTable to perform the insertion." The below might be correct: "...feeding that up to Mod

gettext instructions for Windows seems wrong

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/install-windows-full.html Description: I have to build Postgres on Windows 10. I got everything building from a git checkout without NLS. I followed the instructions the way I understood t

idle_session_timeout doc

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/runtime-config-client.html Description: Is there a way to alter users idle_session_timeout setting? My understanding is that it's a global setting. The last sentence indicates you can ap

Not clear sentence

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/backup-dump.html Description: URL: https://www.postgresql.org/docs/current/backup-dump.html Text: This is necessary to fully backup the cluster if running the pg_dump command on individu

array_to_string and string_to_array

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-array.html Description: Hi, I suggest it would be wise to extend the definition of array_to_string (Table 9.52) by linking to string_to_array (Table 9.10). It would also be wise

Conventions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/notation.html Description: In section 3, Conventions, it would be helpful to point out that parentheses, when used in the command descriptions, are to be interpreted as literal required el

Datetime formatting

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-datetime.html Description: The latest ISO 8601-1:2019 standard requires the "T" character as the separator in text representations of datetimes. RFC 3339 is more flexible and all

documentation typo

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/lo-interfaces.html Description: I assume "inv_oid = lo_creat(conn, INV_READ|INV_WRITE);" should be "inv_oid = lo_create(conn, INV_READ|INV_WRITE);", right? https://www.postgresql.org/docs/

Minor error in calling a python list a tuple

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpython-data.html Description: Hello, In the link bellow there is the mentioned error. https://www.postgresql.org/docs/13/plpython-data.html#PLPYTHON-ARRAYS CREATE FUNCTION make_pair (na

Transactions in postgres

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-transactions.html Description: What is discussed in the transaction article is valid as long as the commit is made in the place where the stored procedure was invoked, since if th

CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createtableas.html Description: If I create a table with CREATE TABLE IF NOT EXISTS table_name AS, and the table exists already, I get a NOTICE instead of an ERROR. I wanted to have i

Data Type Size Calculation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-numeric.html Description: > The actual storage requirement is two bytes for each group of four decimal digits, plus three to eight bytes overhead. Please describe what 'overhead'

Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createview.html Description: What the doc says about CREATE OR REPLACE VIEW : "The new query must generate the same columns that were generated by the existing view query (that is, th

tutorial problem solution requires that problem is already fixed

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/role-attributes.html Description: I am reporting my roadblock, so it can be better documented in the future. I am following this tutorial: https://www.postgresql.org/docs/14/tutorial-crea

<    5   6   7   8   9   10   11   12   13   >