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
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.
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
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/libpq-ssl.html
Description:
PQinitSSL's explanation might be wrong.
> Allows applications to select which security libraries to initialize.
We cannot select the library to initialize
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/indexes-expressional.html
Description:
It appears as if the paragraph beginning: "If we were to declare this index
UNIQUE..."
actually belongs just before the paragraph beginning:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-creategroup.html
Description:
Hello,
This page says that "CREATE GROUP is now an alias for CREATE ROLE.",
But when u check the CREATE ROLE, u see they have different options,
I don't
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/pgarchivecleanup.html
Description:
In various places of version 12 documentation, recovery.conf -file is
mentioned.
I thought that the file no longer existed in version 12?
Yours truly
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/wal-async-commit.html
Description:
In this page:
https://www.postgresql.org/docs/current/wal-async-commit.html
In this paragraph:
Certain utility commands, for instance DROP TABLE, are
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/wal-configuration.html
Description:
In the WAL configuration chapter, one finds this sentence:
On Linux and POSIX platforms checkpoint_flush_after allows to force the OS
that pages
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' ^@
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
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
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-join.html
Description:
Actually, it is good practice to avoid using 'cross joins' and use the
'inner join' syntax. Most query planners might optimize both queries to run
the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/bug-reporting.html
Description:
pg_stat_statements is recording passwords also, is there any way to avoid
the logging of passwords without droping extension package.
testdb=> create user
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-createsubscription.html
Description:
[update to my last message]
Hi, i'm using v10. Naming is deferent between publication and
subscription.
Create publication "PubAll
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/sql-createsubscription.html
Description:
Hi, i'm using v10 and
Create publication "PubAll Master(192.168.1.180) Slave(192.168.1.185)"
Works fine, but
Create publication "suball
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/index.html
Description:
In the PDF documentation, some table columns overflow and overlap with the
next column. This makes the content of both columns unreadable.
Please see the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/queries-table-expressions.html
Description:
The explanation of ROWS FROM is fairly terse and no examples are given.
As it is essentially impossible to usefully search for this phrase, it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/functions-math.html
Description:
The ceil, ceiling, and floor mathematical functions in documentation
versions 9.5 through 12, and probably others is not correct. The example
output
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 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
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
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
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
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/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
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
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-altersubscription.html
Description:
If the logical replication subscription is owned by a role that is not
allowed to login (for example, if the LOGIN privilege is removed after the
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
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
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/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
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/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
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
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'.
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
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
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
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
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
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 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]
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
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.
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
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/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/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/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
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"
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
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
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
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
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
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,
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/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/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,
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/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
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
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
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
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/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
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
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
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%
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/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
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)
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()
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
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
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/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
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
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/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/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"
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
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
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
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/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"
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/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
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
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
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
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
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/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
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
301 - 400 of 949 matches
Mail list logo