The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ltree.html
Description:
The ltree docs available at
https://www.postgresql.org/docs/current/ltree.html state "Comparison sorts
in the order of a tree traversal" without specifying the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/install-make.html
Description:
Hello there,
Below are complete steps for building Postgres from source in a clean docker
ubuntu container.
Maybe this is useful for your docs? I noticed
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/logical-replication-col-lists.html
Description:
The documentation on this page mentions:
"If no column list is specified, any columns added later are automatically
replicated."
It feels
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/catalog-pg-proc.html
Description:
I don't know if this is a documentation problem or an error in pg_proc.
The document, for the "prokind" column state the following:
f for a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/tutorial-arch.html
Description:
PostgreSQL uses a client/server architecture. As is typical of client/server
applications, the client and the server can be on different hosts. In that
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/logical-replication-subscription.html
Description:
I'm reading up on Logical Replication and have been reading the pages in
order.
The first 2 pages:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/logical-replication-publication.html
Description:
The page in question:
https://www.postgresql.org/docs/current/logical-replication-publication.html
It says:
"If a table without a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/collation.html
Description:
I created a collation specifying the ks-level3 setting and with
deterministic set to false. But when I compare "a_b" to "a-b" with this
collation I get false.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/server-start.html
Description:
Hello!
On this page:
https://www.postgresql.org/docs/14/server-start.html#CLIENT-CONNECTION-PROBLEMS
It notes: " A common mistake is to forget to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ddl-partitioning.html
Description:
There is no example showing the syntax of Hash Partitioning in this section
of the documentation, it's missing.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-select.html
Description:
Dear PostgreSQL Team,
I'm writing to seek clarification regarding the scope of the formal syntax
outlined in the documentation for the SELECT statement
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/predefined-roles.html
Description:
roles that have the CREATEROLE privilege can no longer GRANT predefined
roles unless they are part of it having the WITH ADMIN option. this needs to
be
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/app-pg-ctl.html
Description:
I have used postgresql@14 for several years and have always used pg_ctl to
start the postgres server, check status etc.
I tried upgrading to postgresql@15
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/datatype-pseudo.html
Description:
I tryed to implement a safe_cast function with 2 parameters and a return of
type "any" but it failed. I get a syntax error, if I use "any" as a data
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/app-psql.html
Description:
On this page https://www.postgresql.org/docs/current/app-psql.html
where is? >> `( if there is an unmatched left parenthesis`
```sql
testdb=> SELECT t1.first
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/postgres-fdw.html
Description:
Hi,
The
https://www.postgresql.org/docs/current/postgres-fdw.html#POSTGRES-FDW-OPTIONS-REMOTE-EXECUTION
section mentions for `extensions` configuration
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/functions-formatting.html
Description:
I'm not sure that there will be 31 days in 11 months; although postgresql
probably knows better what will happen in 2
For example (with the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/app-psql.html
Description:
option -X,
the specified comma after the letter X
https://www.postgresql.org/docs/current/app-psql.html
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/datatype-json.html
Description:
Using subscripts with square brackets is not supported, one must use -> or
#> operators
The given examples result in error:
SELECT ('{"a":
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/plpgsql-declarations.html
Description:
Under 43.3.1, "Notice that we omitted RETURNS real — we could have included
it, but it would be redundant."
Should that be "RETURNS tax" instead of
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/textsearch-controls.html
Description:
This is a followup to
https://www.postgresql.org/message-id/171175476214.7104.6233899851600749789%40wrigleys.postgresql.org
I am a developer on the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/explicit-locking.html
Description:
Hello,
It appears that LOCK on a schema.table requires particular permissions but I
can’t find which ones need to be granted in a schema.table in order
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/pgcrypto.html
Description:
Hi
Regarding the page for pg_crypto:
https://www.postgresql.org/docs/current/pgcrypto.html
A worked example would really help with this, especially for those
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/bug-reporting.html
Description:
Need a PostgreSQL 16 developer edition for enabling vector support.
We want to compile a vector extension in the postgres 16 dev edition and
use
the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/runtime-config-client.html
Description:
Thanks for the cool product. One comment concerning the lock_timeout
parameter:
The documentation states here:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/sql-altertable.html
Description:
Hello dear PostgreSQL family,
It is not entirely clear (to me) that ALTER TABLE statements with
comma-separated sub-commands are atomic. Despite of
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/textsearch-controls.html
Description:
My team recently ran into a performance issue that turned out to involve
ts_headline, so I've been looking at the documentation. In 12.3.4.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-createrole.html
Description:
https://www.postgresql.org/docs/16/sql-createrole.html
ROLE role_name
The ROLE clause causes one or more specified existing roles to be
automatically
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-explain.html
Description:
Hello
Regarding the Explain command's documentation:
https://www.postgresql.org/docs/current/sql-explain.html
For non-text format options (JSON, YAML, XML)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/datatype-money.html
Description:
It's not explicitly obvious that money doesn't behave like a normal numeric
type in that executing a procedure with a negative numeric value for money
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/intarray.html
Description:
Hi,
I recently ran into an unusual issue with the intarray extension where if
you subtract one array from another the result is *also* sorted and
de-duplicated.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/mvcc-intro.html
Description:
There really needs to be an explicit warning that the following is invalid
in normal read committed mode:-
select foo into f from bar where id=1;
f = f +
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/app-pg-isready.html
Description:
Hello,
The documentation does not specify what are the minimum required permissions
for setting up pg_isready .
I was wondering if this could be added so
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/view-pg-stats.html
Description:
https://www.postgresql.org/docs/current/view-pg-stats.html#VIEW-PG-STATS
It seems the ending clarifying sentence:
"(Null when most_common_vals is.)"
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/runtime-config-query.html
Description:
While reading the following section in the documentation
https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-RANDOM-PAGE-COST
I
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/warm-standby.html
Description:
Section, 27.2.8.4. Planning For High Availability is missing the word "the"
as shown below ..
"Such transaction commits may never be completed if any one of
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/functions-datetime.html
Description:
Dear PostgreSQL Developers,
I have encountered a potential issue with the interval calculation when
adding 1 year to a non-leap year. The behavior
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/libpq-pipeline-mode.html
Description:
The calls to PQpipelineSync and PQsendFlushRequest may either report failure
or success, but not that data could not be written as of yet because the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/app-pgrewind.html
Description:
After the sentence
"all other files, including new relation files, configuration files, and WAL
segments, are copied in full."
we should add
"However, no
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/runtime-config-connection.html
Description:
In the documentation, I read:
20.3.1. Connection Settings
listen_addresses (string)
Specifies the TCP/IP address(es) on which the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/plpython.html
Description:
Hi everyone,
I am currently trying to install PL/Python on Windows and noticed that no
documentation for that currently exists (I hope I didn't miss anything).
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/bug-reporting.html
Description:
Dear PostgreSQL Documentation Team,
I hope this message finds you well. As a user and admirer of PostgreSQL, I
greatly appreciate the effort and detail
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/functions-string.html
Description:
Hey,
I was confused by substring behavior today, when giving 0 as a start
position. I understand now that string indices are 1-based, have a certain
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ecpg-informix-compat.html
Description:
Chapter 36. ECPG — Embedded SQL in C
36.15. Informix Compatibility Mode
The first sentence in dectoint() and dectolong() function's descriptions
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/features-sql-standard.html
Description:
In "D.1. Supported
Features"(https://www.postgresql.org/docs/current/features-sql-standard.html),
identifiers appear as following:
F302
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-createfunction.html
Description:
the documentation for creating a function shows [ RETURNS rettype | RETURNS
TABLE ( column_name column_type [, ...] ) ] but returns is not optional.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-security-label.html
Description:
Hi,
FOREIGN TABLE object_name
...probably should have a following "|", I think?
Cheers
Tim
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/bloom.html
Description:
Created the table with exact scripts provided and the index size was;
SELECT pg_size_pretty(pg_relation_size('btreeidx'));
386 MB
SELECT
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/pgcrypto.html
Description:
I was going through the links in pgcrypto documentation and I realized that
one of the links at Useful Reading section do not work.
interhack.net seems to be
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/runtime-config-resource.html
Description:
Would be nice to add the limits to the doc, according to my pg15 instance I
can't set bgwriter_delay more than 1 ms. (I set it to 60 s and
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/datatype-character.html
Description:
The documentation implies that the data types text and varchar are
equivalent, but this is not the case with this test in Postgresql version
16.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-createdatabase.html
Description:
Hi,
[ STRATEGY [=] strategy ] ]
...has a superfluous ], I think?
Tim
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/bug-reporting.html
Description:
Hello,
in
https://www.postgresql.org/docs/16/continuous-archiving.html#BACKUP-ARCHIVING-WAL
the example given could be improved for Linux / Unix
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/runtime-config-wal.html
Description:
The sentence in commit_siblings "A larger value makes it more probable that
at least one other transaction will become ready to commit during the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ddl-system-columns.html
Description:
Will be clear to have a picture of how they are in the database.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/recovery-config.html
Description:
This page has a link that says "See the release notes for PostgreSQL 12 for
details on this change."
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/auth-username-maps.html
Description:
Hello.
I am not sure, but 'can be include directives' looks very strange to me:
As for pg_hba.conf, the lines in this file can be include directives,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/auth-cert.html
Description:
Hello.
This page missed information about supported clientname=CN/DN option and
describes only `map` option.
Also `clientcert` is described not in format. I
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/auth-pg-hba-conf.html
Description:
Hello.
On this page this command does not work
`openssl x509 -in myclient.crt -noout --subject -nameopt RFC2253`
unknown option --subject
We should use
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-set-role.html
Description:
"SET ROLE has effects comparable to SET SESSION AUTHORIZATION, but the
privilege checks involved are quite different."
What are the differences in
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/protocol-flow.html
Description:
Greeting!
Please consider the following exchange with a PG database (Kotlin + Reactor+
r2dbc-postgresql):
```
2951.063166127.0.0.1 50591
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/tutorial-join.html
Description:
CREATE EXTENSION plpython3u;
[2024-01-25 05:56:50] [58P01] ERROR: could not load library "C:/Program
Files/PostgreSQL/16/lib/plpython3.dll": The specified
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/continuous-archiving.html
Description:
Hi!
I'm reading through the documentation and so far I have to say this is the
best documentation I have ever encountered, thank you!
I noticed,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/tutorial-populate.html
Description:
COPY weather FROM '/home/user/weather.txt'; is not working it requires
additional commands for me.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/tutorial-sql-intro.html
Description:
" Directory of C:\postgresql-16.1\src\tutorial
11/06/2023 11:17 PM .
11/06/2023 11:17 PM ..
11/06/2023 11:04 PM
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/routine-vacuuming.html
Description:
In
https://www.postgresql.org/docs/current/routine-vacuuming.html
section "25.1.5. Preventing Transaction ID Wraparound Failures" there is a
5-step
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/ddl-constraints.html
Description:
Dear postgres Team,
I happened to have stumbled across a tricky to read sentence in Ch. 5.45
'Foreign Keys' (Postgres Version 15).
The original
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/plpython-subtransaction.html
Description:
On page
https://www.postgresql.org/docs/current/plpython-subtransaction.html,
Note that the use of try/catch is still required.
should read
Note
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/unaccent.html
Description:
I'm trying to query a database with unaccent, but PostgreSQL gives me
exceptions:
ERROR: function unaccent(character varying) does not exist at character
139
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/install-make.html
Description:
Hello, I Hope you've enjoyed a festive period.
Thanks for all your hard work, postgres is amazing. Small suggestion for
installation instructions on debian
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/functions-aggregate.html
Description:
Please add the argument "distinct" to the documentation of the
aggregate-function "string_agg". It's used to omit any duplicates in the
result
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ddl-priv.html
Description:
Hello.
The page https://www.postgresql.org/docs/current/ddl-priv.html does not
describe what =Tc/user means. Also I did not find a link to appropriate page
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/tutorial-table.html
Description:
The text in: 2.3. Creating a New Table, states:
"... you can type the command aligned differently than above, or even all on
one line. Two dashes (“--”)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-alterforeigndatawrapper.html
Description:
Hi,
Re. this example:
ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP 'bar');
I think "bar" is akin to "foo" and therefore
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-syntax-lexical.html
Description:
it just threw me off to read the exact same thing twice in quick succession,
I'd suggest linking to section 4.1.2.3 in section 4.1.1 instead.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/preventing-server-spoofing.html
Description:
When I read:
To prevent spoofing on TCP connections, either use SSL certificates and make
sure that clients check the server's certificate, or
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/view-pg-stats.html
Description:
First paragraph for the pg_stats view says: "This view allows access only to
rows of pg_statistic that correspond to tables the user has permission to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-select.html
Description:
At the top of the sql-select page it says
"If ORDER BY is not given, the rows are returned in whatever order the
system finds fastest to produce."
but later
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-alterdomain.html
Description:
(apologies, I managed to send this too soon, just now, somehow)
The example for ALTER DOMAIN shows:
ALTER DOMAIN zipcode ADD CONSTRAINT zipchk CHECK
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/libpq-ssl.html
Description:
I noticed that it would be helpful to list the connection parameters and
environment variables for the various SSL files in the table "Table 34.2.
Libpq/Client
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/app-pgrestore.html
Description:
After creating a new database in postgreSQL :
CREATE DATABASE x;
I dump it in a .tar file:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/datatype-datetime.html
Description:
Hello,
In the interval example outputs, for postgres and postgres_verbose.
It says mons instead of months.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/tutorial-agg.html
Description:
There are two documentation pages with the same title "Aggregate Functions".
One describes what they are and one lists all of them. The two pages should
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-createtable.html
Description:
It is not clear to me that foreign keys are copied or not when duplicating a
table using CREATE TABLE ... LIKE ... INCLUDING ALL. I had to actually test
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/manage-ag-tablespaces.html
Description:
While reading the table-space documentation
https://www.postgresql.org/docs/16/manage-ag-tablespaces.html the
information I was looking for was not
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/datatype.html
Description:
I think there could be some clarification of what is a "name" vs. "alias" on
the datatypes table. Right now, what's in the "Aliases" column is sometimes
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/tutorial-createdb.html
Description:
You might want to mention that createdb will give no feedback after creating
database. Neither will dropdb.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-notify.html
Description:
It would be good to add to the notes section that use of NOTIFY especially
within a TRIGGER requires an AccessExclusiveLock which may cause performance
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/git.html
Description:
>ISO 8601 specifies the use of uppercase letter T to separate the date and
time. PostgreSQL accepts that format on input, but on output it uses a space
rather than
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-select.html
Description:
Hi,
To be consistent, the "with" example should end in a ";".
WITH t AS (
SELECT random() as x FROM generate_series(1, 3)
)
SELECT * FROM t
UNION ALL
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/acronyms.html
Description:
while reading the progres codebase, i could find you're using the acronym
"AM" which denotes "Access Method". it's be nice to add it to the list of
acronyms
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/15/logical-replication-row-filter.html
Description:
Hey I'm using create subscription to subscribe to a table. I have two
different hosts and I want to setup replication between them.
In
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/indexes-unique.html
Description:
I would like to request an improvement to the PostgreSQL documentation,
specifically in the sections "11.6. Unique Indexes" and "11.8. Partial
Indexes."
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/datatype-json.html
Description:
https://dbfiddle.uk/Dr-c-nqL
multiple subscripts for jsonb arrays do not behave as described on Table
8.25 in Postgres 16 docs / 8.14.7 jsonpath
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/sql-createtableas.html
Description:
Since I was recently bitten by the fact that CREATE TABLE AS doesn't set the
PL/pgSQL variable FOUND, it would be nice if that were explicitly noted in
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/functions-string.html
Description:
https://www.postgresql.org/docs/16/functions-string.html
Said
text ^@ text → boolean
Returns true if the first string starts with the second string
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/textsearch-limitations.html
Description:
Hello,
In the FTS/Limitations part of the documentation, it says :
"Another example — the PostgreSQL mailing list archives contained 910,989
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/app-pg-isready.html
Description:
the --dbname option in pg_isready seems not to work propperly. the tool
returns 'ok' as long as the cluster itselft is running, no matter how wrong
the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ssl-tcp.html
Description:
There is no mention of key lengths on the manual page about SSL/TLS
connections even though there are restrictions. It probably depends on the
build which is
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/16/ecpg-sql-set-connection.html
Description:
In the documentation for Postgres 15, on page
https://www.postgresql.org/docs/15/ecpg-sql-set-connection.html, it states
that one can write:
SET
1 - 100 of 949 matches
Mail list logo