The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/libpq-pgpass.html
Description:
Hi All,
It's not actually a problem, it's a question. pgpass in my case, has two
lines, one with 127.0.0.1 and another with localhost
what would be the d
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-copy.html
Description:
Look at the account of the COPY statement, here:
https://www.postgresql.org/docs/11/sql-copy.html
and see this:
«
[ [ WITH ] ( option [, ...] ) ]
»
It goes o
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/runtime-config-resource.html
Description:
https://www.postgresql.org/docs/13/runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER
says:
"There is a separate server proc
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/libpq-threading.html
Description:
On page https://www.postgresql.org/docs/13/libpq-exec.html, non-existing
directory is mentioned: src/tools/thread.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/libpq-exec.html
Description:
On page https://www.postgresql.org/docs/13/libpq-exec.html, non-existing
file is mentioned: src/include/catalog/pg_type_d.h. We fail to find it in
this catalog
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/logical-replication-publication.html
Description:
Hi,
On this page,
https://www.postgresql.org/docs/12/logical-replication-publication.html
The first line states: A publication can be
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/using-explain.html
Description:
I am reading 14.1.1 and at the very end (just before 14.1.2) I see:
"which shows that the planner thinks that sorting onek by index-scanning is
about 12% m
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/errcodes-appendix.html
Description:
02000 no_data
should read no_data_found
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/client-authentication-problems.html
Description:
The article on authentication problems refers to "the log" and the "server
log" but lacks information on where to find that log or how to c
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/plpgsql-control-structures.html
Description:
Search for the word indeed found here
https://www.postgresql.org/docs/13/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING-PROCEDURE
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/postgres-user.html
Description:
The page describes the postgres user typically used as superuser for a
PostgreSQL cluster.
It would be useful to add information about best practices concer
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-sequence.html
Description:
This page:
https://www.postgresql.org/docs/current/functions-sequence.html
doesn't seem to mention that there's a way to get the "cross session"
curren
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/tutorial-join.html
Description:
This page references a "cities" table, but not prior page showed this table.
Suggest adding a new "cities" table on this page.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/plpgsql-control-structures.html
Description:
42.6.8.1. Obtaining Information About An Error
This example omits raise notice code:
DECLARE
text_var1 text;
text_var2 text;
text_var3
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/install-procedure.html
Description:
Online doc states
[...], or set the variables XML2_CFLAGS and XML2_LIBS. (If
pkg-config is installed, then to override its idea of where libxml
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/collation.html
Description:
If exists statistic with nondeteministic collation inherited from column
collation then using pattern matching with collation will give an error.
There is no in
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/arrays.html
Description:
Documentation should mention single quotes in "array value as a literal
constant" description.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-json.html
Description:
Compare:
* https://www.postgresql.org/docs/13/functions-json.html
* https://www.postgresql.org/docs/12/functions-json.html
I know it is just my opinion, b
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/libpq-ssl.html
Description:
The instruction to use "chmod og-rwx" could leave the file with read
permission set. Elsewhere the suggestion is "chmod 600".
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/wal.html
Description:
Hello!
In "25.3.3.2. Making An Exclusive Low-Level Backup", you said that "The
exclusive backup method is deprecated and should be avoided. Prior to
PostgreSQL 9.6, t
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-populate.html
Description:
My suggestion is that links be placed in the tutorial for the support files
(such as weather.txt, basics.sql, ...)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/index-unique-checks.html
Description:
When there are multiple unique indexes on a table, at least one that allows
NULL, the order of the locks are important. This should be explained in t
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/protocol-message-formats.html
Description:
On page: https://www.postgresql.org/docs/11/protocol-message-formats.html
it says for SSLRequest packet:
Int32(80877103)
The SSL request code.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/protocol-message-types.html
Description:
I'm creating a postgresql client in gdscript (you can answer my question
even if you don't know how to code in gdscript).
To do this I use the pos
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-logging.html
Description:
Hi!
In section "19.8.3. What to Log" appears "application name (string)"
parameter which is not in the postgresql.conf configuration file.
Is it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-alterdefaultprivileges.html
Description:
The documentation on ALTER DEFAULT PRIVILEGES currently defines the
parameter target_role like this:
> The name of an existing role of which t
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/pgtrgm.html
Description:
https://www.postgresql.org/docs/12/pgtrgm.html states that "similarity(text,
text) realReturns a number that indicates how similar the two arguments
are. The
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/queries.html
Description:
I like to browse documentation by index rather than searching. The Postgres
documentation is fairly well organized so this is easy for most topics.
However, on th
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/contrib-dblink-connect.html
Description:
In this section of dblink_connect
```
CREATE SERVER fdtest FOREIGN DATA WRAPPER dblink_fdw OPTIONS (hostaddr
'127.0.0.1', dbname 'contrib_regressio
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/biblio.html
Description:
Ullmann's classic should be
[ull88]
Principles of Database and Knowledge-Base Systems.
Jeffrey D. Ullman. Volume 1. Computer Science Press. 1988.
not
[ull88]
P
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-query.html
Description:
I recently have an observation that the combination of random_page_cost and
parallel_leader_participation can cause a performance regression. However
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/ssh-tunnels.html
Description:
"The first number in the -L argument, 6, is the port number of your end
of the tunnel; it can be any unused port. (IANA reserves ports 49152 through
6553
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/app-pgbasebackup.html
Description:
PG_Basebackup not compatible with the version 12.3
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/xfunc-c.html
Description:
In "Table 35-1. Equivalent C Types for Built-in SQL Types", when SQL type is
"timestamp", the C type is reported to be "Timestamp * ", whereas it is
actually "Tim
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-logging.html
Description:
There is some imperfection in PostgreSQL doc. There are two section in
documentation how to import PostgreSQL log into sql space and both not
comp
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/app-pgbasebackup.html
Description:
The pg_basebackup page says that the --waldir parameter "Specifies the
location for the write-ahead log directory. waldir must be an absolute path.
The w
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-wal.html
Description:
Hello,
First of all I would like to say that PostgreSQL has the best documentation
I've ever seen. It is very clear and comprehensive. That's the main
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/gin-implementation.html
Description:
In the part 'when the list is small enough to fit into a single index
"tuple" along with the key value' should the word "tuple" be replaced by the
word
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/functions-json.html
Description:
It is not clear what the parameter `base` means
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/datatype.html
Description:
Thank you for perfect documentation. Please add subchapter about discovering
types. Themes like List all available types, Get type of column with
pg_typeof() fun
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/functions-textsearch.html
Description:
A suggestion. This page, "functions-textsearch", is fine, and the best
place to explain functions like array_to_tsvector() and jsonb_to_tsvector()
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-createprocedure.html
Description:
The information on procedures could helpfully include that the feature is
new from PostgreSQL 11 and give an explanation of how it differs from
functi
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/mvcc-intro.html
Description:
The documentation page:
__https://www.postgresql.org/docs/12/mvcc-intro.html
makes a reference to the term "innovative Serializable Snapshot Isolation
(SSI) le
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/datatype-numeric.html
Description:
When I try to run
`insert into employees (r_id) values (3.919192199);`
where r_id is of type real, I see it stores as 3.9191923 and not 6.
Am I unders
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/ddl-partitioning.html
Description:
With version 12 using declarative partitioning request that the column used
for patitioning is part of the PRIMARY KEY of the table as you can see in
the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-inheritance.html
Description:
Hello Team,
https://www.postgresql.org/docs/current/tutorial-inheritance.html
There is the sentence in section 3.6: "State capitals have an extra c
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-fk.html
Description:
It was my mistake, please ignore it. Sorry I don't know how to recall
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-fk.html
Description:
Hello
Thank you for your great tutorial.
I wasn't able to compile the below without a 'not null' after the primary
key word:
https://www.postgresql.org/doc
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/libpq-connect.html
Description:
I am looking for a complete list of parameters that I can pass in the
"connect"/"open database connection" list on the client (in this case,
github.com/lib/
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-string.html
Description:
I cannot get psql to accept an UTF8 string, link update .. set ... =
'josé';
In the docpage on encodings, jose is used in examples for UTF8.
Plainly this
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/manage-ag-overview.html
Description:
The sentence has a typo: "If one PostgreSQL server instance is to house
projects or users that should be separate and for the most part unaware of
each
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/datatype-json.html
Description:
https://www.postgresql.org/docs/12/datatype-json.html#JSON-INDEXING
SELECT jdoc->'guid', jdoc->'name' FROM api WHERE jdoc @@ '$.tags[*] ? (@ ==
"qui")';
S
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-expressions.html
Description:
Section 4.2.3. Subscripts of the documentation states:
> Each subscript is itself an expression, which must yield an integer
value.
However, the followi
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/manage-ag-overview.html
Description:
this sentence looks strange:
"Schemas are a purely logical structure and who can access what is managed
by the privilege system"
https://www.postgresql
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-join.html
Description:
The documentation at https://www.postgresql.org/docs/12/tutorial-join.html
shows this query:
SELECT *
FROM weather, cities
WHERE city = name;
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/creating-cluster.html
Description:
I'm searching for what a cluster is and how to create one. The
documentation tells me to use initdb -D path/to/cluster. I am told that
this is installe
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/datatype-datetime.html
Description:
Thank you for lot of examples about date, time an timestamp.
I am missing how to work with unix (date)time(stamps) from epoch, e.g.
1592203289.310 for 2
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/ddl-constraints.html
Description:
As asked here,
https://dba.stackexchange.com/questions/270567/can-a-foreign-key-be-referring-to-the-same-table-as-the-source
the documentation specifies t
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html
Description:
Hello,
We are looking to use transaction management and have run into a limitation
when the procedure is security definer. There doesn't appear to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-createprocedure.html
Description:
Hi all,
The Create Procedure could be improved:
- Provide more examples;
- Describe the use of IN and INOUT variables;
- Describe the use of cursors
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-reindex.html
Description:
Hello,
I am using this command to reindex the databases for a PostgreSQL 10
cluster.
What I can not find in the reindex explanation page is how is this affect
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/user-manag.html
Description:
Thank you for perfect documentation.
I am missing in chapter 21 (Database roles) a section about *listing roles*
both as psql commands and selects to catalogue
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/indexes-types.html
Description:
Can you please add a link to an explanation for physical block ranges of a
table under the BRIN index. This is not explained in the index and might be
conf
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-createindex.html
Description:
Hello!
I noticed an slight inaccuracy in the documentation for CREATE INDEX and
ALTER INDEX:
CREATE INDEX ... [ WITH ( storage_parameter = value [, ... ]
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/arrays.html
Description:
In the last code block in "8.15.5. Searching in Arrays", the column title in
the output is "array_positions" for both examples, but it should be
"array_position" f
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/ecpg-pgtypes.html
Description:
Hello! In example of usage PGTYPESinterval_free used PGTYPESinterval_new.
Should be PGTYPESinterval_free.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/queries-order.html
Description:
Hi,
Good day :)
It seems Postgre supports following feature: E121-02ORDER BY columns need
not be in select list. But please add postgre behavior for "se
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/datatype-numeric.html
Description:
I think the documentation should mention that these do much the same thing
(at least, for the default auto-incrementing integer sequence). Using both
on
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/bug-reporting.html
Description:
Hi
I was stumbling across the trigger function
‘suppress_redundant_updates_trigger’ in
https://www.postgresql.org/docs/devel/functions-trigger.html and I w
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/protocol-message-types.html
Description:
Hi, I'm the maintainer of Npgsql, the .NET open source driver for
PostgreSQL.
The protocol docs generally do not mention whether ints are signed o
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-grant.html
Description:
Having read through the documentation on roles/granting I think I more or
less understand how it works, but what isn't really clarified is what the
overall univ
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-createdatabase.html
Description:
My understanding is that not copying the ACL is the (currently) expected
behavior when issuing CREATE DATABASE newdb WITH TEMPLATE my_tmpl;
It would be
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/functions-formatting.html
Description:
For the formatting functions, which convert between a string and a type like
date, timestamp or number, there should be a description about the behav
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/app-pgbasebackup.html
Description:
Only since Postgres 10, one can take backup of wals along with full backup
(in tar format) using pg_basebackup
ERROR:
pg_basebackup: WAL streaming can
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/bug-reporting.html
Description:
Now i installed postgresql but i am facing error like "There was been an
error unknown error while ruining c:/WINDOWS/system32//whoami...
please help to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/functions-binarystring.html
Description:
On the page:
https://www.postgresql.org/docs/12/functions-binarystring.html
The result for decode('123\000456', 'escape') is incorrect, it should
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/rules-views.html
Description:
I am looking a way to get exact view definition, for ex :
CREATE TABLE t1(id int,name varchar);
INSERT INTO t1 values(1,'n1'),(2,'n2');
CREATE V
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-wal.html
Description:
About parameter max_wal_size the documentation says that "Maximum size to
let the WAL grow to between automatic WAL checkpoints."
Is it correct?
The si
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/encryption-options.html
Description:
Chapter 18. Server Setup and Operation
18.8. Encryption Options
Under the topic "Encrypting Data Across A Network", I think there seems to
be a docume
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-createextension.html
Description:
Excuse me I'm having a problem that I cannot create an extension in the
database, so would you mind helping me solve the problem.
When I create extens
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-join.html
Description:
The tutorial about joins makes the following statement about the explicit
JOIN operator:
> This syntax is not as commonly used as the one above
I think in
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/indexes-expressional.html
Description:
The paragraph that begins "If we were to declare this index UNIQUE,..."
refers to the index test1_lower_col1_idx, not to the test1_uniq_int index it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-createdb.html
Description:
I am at this point in the documentation and I'm told to type a command.
"1.3. Creating a Database
The first test to see whether you can access the data
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-string.html
Description:
The second line in "Table 9.8. SQL String Functions and Operators" uses
"non-string or non-string" as part of the example. I assume one of these
should b
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/ddl-constraints.html
Description:
I think the information about the "order of execution" when checking CHECK
constraints when inserting or updating records is missing in the
documentation
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/typeconv-union-case.html
Description:
I think it should be CAST instead of CASE.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-sql-intro.html
Description:
is wrong.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/runtime-config-autovacuum.html
Description:
The `autovacuum_vacuum_cost_delay` setting changes to 2ms in PostgreSQL 12
but in the old Postgresql version, the default setting is still 20ms.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/app-psql.html
Description:
Hi, first of all thanks for the great postgres database and its psql
utility.
Today I had some trouble using "COPY ... FROM STDIN" with CSV data piped
into the p
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/functions-math.html
Description:
Proposed rewording for ceil() and ceiling(): "smallest integer..."
Proposed rewording for floor(): "greatest integer..."
Rationale: the proposed rewording
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/catalogs-overview.html
Description:
The documentation for chapter 52 does not clearly identify the schema
associated with the system catalogs in either the chapter header or overview
secti
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/app-psql.html
Description:
Since https://www.postgresql.org/docs/current/app-psql.html is quite long,
it would be nice to add a detailed table of contents at its beginning, in
order to:
-
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-wal.html
Description:
Would it be possible to add "edit this page" links to every PostgreSQL doc
page, pointing to the docs git repo, ideally on a site that allows
on-the-si
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/app-pgrestore.html
Description:
"-C
--create
Create the database before restoring into it. If --clean is also
specified, drop and recreate the target database before connecting to it.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/protocol-flow.html
Description:
In "52.2.2.1. Multiple Statements in a Simple Query" there is supposed to be
a typo in the last example.
I cannot find it, even having diffed the two exampl
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-createprocedure.html
Description:
In https://www.postgresql.org/docs/12/sql-createprocedure.html you can add:
"It is also not possible to change the argname. Trying to do so will raise
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/release-10-7.html
Description:
Following is our finding:
Postgres query behaves differently in 2 version
Specifically
(json_agg(DISTINCT table_name.*) filter(where table_name is not
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-wal.html
Description:
The PostgreSQL manual contains the following paragraph
https://www.postgresql.org/docs/current/runtime-config-wal.html#GUC-ARCHIVE-TIMEOUT
about the ar
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/functions-string.html
Description:
Preparing to upgrade old PostgreSQL and looking changelog, I has found log
about "prefix text match" operator (boosted by SP_GIST):
=> select 'ab' ^@ 'a'
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/runtime-config-resource.html
Description:
https://www.postgresql.org/docs/11/runtime-config-resource.html says:
--snip--
temp_buffers (integer):
Sets the maximum number of tempora
601 - 700 of 1134 matches
Mail list logo
