The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/ddl-rowsecurity.html
Description:
On this page I see the following example:
cut
=> SELECT current_user;
current_user
--
admin
(1 row)
=> select inet_client_addr();
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/role-membership.html
Description:
I guess the phrase
because joe “inherits” admin's privileges
should be changed to
because joe was granted admin's privileges.
The point is, otherwise
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/ecpg-sql-set-autocommit.html
Description:
I tested with " PostgreSQL 13.2 on x86_64-pc-linux-gnu, compiled by gcc
(GCC) 8.3.1 20191121 (Red Hat 8.3.1-5), 64-bit"
The result is below.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/tutorial-sql-intro.html
Description:
https://www.postgresql.org/docs/13/tutorial-sql-intro.html
This page tells how to make tutorial files:
$ cd .../src/tutorial
$ make
I have a binary
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/tutorial-join.html
Description:
This page shows a WHERE syntax to join tables.
After that it shows an example of the INNER JOIN syntax:
SELECT *
FROM weather INNER JOIN cities ON
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/continuous-archiving.html
Description:
Under the steps of Recovering with continuous logging, Step 8 says:
"Start the server. The server will go into recovery mode and proceed to read
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-createrole.html
Description:
"modified by later ALTER ROLE" to be changed to "modified later by ALTER
ROLE".
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/tutorial-advanced-intro.html
Description:
I built tutorial files according to instructions from the section 2.1. And I
found that the script advanced.sql covers only the section "3.6.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-createschema.html
Description:
The second and forth syntax for CREATE SCHEMA is missing schema_name.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/pltcl-trigger.html
Description:
Example on this page is not working
https://www.postgresql.org/docs/13/pltcl-trigger.html
Gives ERROR: bind message supplies 1 parameters, but prepared
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-datetime.html
Description:
Please also include some examples that extract few columns from some
tables.
For e.g. SELECT EXTRACT(YEAR FROM hire_date) FROM Employee WHERE id =
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/datatype-json.html
Description:
Hello,
On the DATATYPE-JSONPATH page:
https://www.postgresql.org/docs/13/datatype-json.html#DATATYPE-JSONPATH
There is a line that shows that GIN indexes
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-sequence.html
Description:
Please add Note, how to get the (global) last value:
SELECT last_value FROM sequence_name;
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/functions-math.html
Description:
The 'round' mathematical function documentation doesn't specify its rounding
strategy. If this would be documented then users can rely on its rounding
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/tutorial-window.html
Description:
Link: https://www.postgresql.org/docs/12/tutorial-window.html
> The first three output columns come directly from the table empsalary, and
there is one
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/app-psql.html
Description:
There is a spurious space inside the documentation:
\set HISTFILE ~/.psql_history- :DBNAME
instead of
\set HISTFILE ~/.psql_history-:DBNAME
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-createprocedure.html
Description:
This documentation is missing the part on the topic whether we can insert
data in temporary table from Stored procedure output.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-syntax-lexical.html
Description:
Simply want to tell you that there is repeated almost word-in-word info in
4.1.1 (starting with "A variant of quoted identifiers allows including",
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/tutorial-createdb.html
Description:
In the getting started documentation, it will have been better to start with
how to 'login to postgres' and cover the idea of 'roles'. Or if previously
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/runtime-config-replication.html
Description:
The documentation says that setting wal_receiver_status_interval to 0
disable updates of replication status completely. However walreceiver
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/routine-vacuuming.html
Description:
Hello,
transaction ID modulo is not correct.
The sentence "Normal XIDs are compared using modulo-2^32 arithmetic" should
be "Normal XIDs are compared
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-alterdefaultprivileges.html
Description:
The syntax/synopsis of the "ALTER DEFAULT PRIVILEGES" statement on the
https://www.postgresql.org/docs/13/sql-alterdefaultprivileges.html page
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-syntax-lexical.html
Description:
Hello, in the bottom part of
https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-IDENTIFIERS
there is an explation about
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/sql-refreshmaterializedview.html
Description:
I hope everyone is well.
I have not found it explicitly specify anywhere but from my experience I
have gathered that when you refresh a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/spi-spi-execute.html
Description:
Hello. I'm using Postgres 9.3.25. I know it's an unsupported version but the
documentation pages that I will mention stay the same between 9.3 and 13.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/continuous-archiving.html
Description:
Hi everyone,
I've been trying out saving and restoring compressed archive logs. The
restore_command stated in the docs at "25.3.6.2. Compressed
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/datatype-json.html
Description:
Hello everyone,
we are planning to test postgres as a nosql database for streaming kafka
events (converted to jsonb) into it next week.
Therefore I am
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/13/legalnotice.html
Description:
1) pgbench has always supported the PGDATABASE env variable, but it is not
listed along PGHOST/PGPORT & PGUSER in
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
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
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
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
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
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
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
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
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".
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
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
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
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
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
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
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
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
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 -
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
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;
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.
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
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.
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
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
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.
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
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
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
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
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
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
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
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=>
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.
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
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
---
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
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
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
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
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
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
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
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
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,
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
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
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
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 *
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
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
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
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
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
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
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
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.
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
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.
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).
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
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
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
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
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
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
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
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:
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
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'
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
501 - 600 of 949 matches
Mail list logo