The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/index.html
Description:
right off the bat, you should have this kind of explanation up there in
chapter 1:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/contrib-dblink-get-result.html
Description:
Please consider clarifying this page:
https://www.postgresql.org/docs/current/static/contrib-dblink-get-result.html
to state that if
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/datatype-json.html
Description:
https://www.postgresql.org/docs/9.4/datatype-json.html
Links to http://rfc7159.net/rfc7159. I get a 403 error for both
http://rfc7159.net/rfc7159 and
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/tutorial-arch.html
Description:
This line:
The user's client (frontend) application that wants to perform database
operations.
in the Architecture
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-altertable.html
Description:
I think it would be useful if the ALTER TABLE page clearly states that when
adding a column to a (declarative) partitioned table, then this new column
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/multibyte.html
Description:
The documentation says that UTF-8 can be converted to any encoding:
UTF8all supported encodings
That's not true:
db => SET CLIENT_ENCODING TO
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/bug-reporting.html
Description:
Hi,
https://www.postgresql.org/docs/10/bug-reporting.html says "For more
information send mail to with the single word
help in the body of the message.".
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-createindex.html
Description:
Link https://www.postgresql.org/docs/current/sql-createindex.html
1. The first paragraph contains in the third sentence an index methods list
- "... The
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/queries-table-expressions.html
Description:
Hi.
https://www.postgresql.org/docs/current/queries-table-expressions.html#QUERIES-LATERAL
>The resulting row(s) are joined as usual with the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/tutorial-createdb.html
Description:
Hi,
I'm following your tutorial to learn PostgreSQL. When I try to create a
database, I keep getting a "password authentication failed" error, that
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-matching.html
Description:
SELECT ' ' SIMILAR TO '[\s]';
returns true
SELECT ' ' SIMILAR TO '[\q]';
generates an error: [2201B]: ERROR: invalid regular expression: invalid
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/index.html
Description:
The documentation on Partitions for PostGreSQL 11 does not document the
DEFAULT partition that can be used to store values that do not match any of
the defined
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/upgrading.html
Description:
https://www.postgresql.org/docs/10/upgrading.html
It would be helpful to make a note for Linux users that you have login
interactively as the postgres user
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/runtime-config-logging.html
Description:
begin cite
client_min_messages (enum)
Controls which message levels are sent to the client. Valid values are
DEBUG5, DEBUG4, DEBUG3, DEBUG2,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/logfile-maintenance.html
Description:
https://www.postgresql.org/docs/10/logfile-maintenance.html
pgBadger link needs to be updated
https://pgbadger.darold.net/
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-json.html
Description:
A really strange behavior has been noticed when trying to extract numeric
key value from jsonb and compare it to a number
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/ddl-schemas.html
Description:
In the last section of the document it says 'If you need to work with those
systems, then maximum portability would be achieved by not using schemas at
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/external-pl.html
Description:
At https://www.postgresql.org/docs/9.4/external-pl.html, the link to PL/Py
is broken. Specifically, the link shown is
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/tutorial-createdb.html
Description:
When I first followed the command, I first couldn't understand which shell
to execute this in - the psql shell or the normal command line. Although a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/planner-stats.html
Description:
There is typo in "14.2.2. Extended Statistics":
> Statistics objects are created using CREATE STATISTICS, which see for more
details.
I think the part
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/citext.html
Description:
The citext plugin does not work in combination with jdbc. Thus it does not
work with Java applications. It does work in pgadmin because that is python.
I am using
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-syntax-lexical.html
Description:
Last paragraph on "4.1.1. Identifiers and Key Words" in the documentation
states:
1.- "[...] unquoted names are always folded to lower case"
2.- "If
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/plpython-subtransaction.html
Description:
The name "transaction" and all examples (update,etc.) are for
transactions... It is not evident for commom reader that we can use
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-dropsubscription.html
Description:
This page has a note about how to set the subscription to not use a slot,
but it doesn't mention that the subscription needs to be disabled first.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/storage-file-layout.html
Description:
I think I found a typo in the manuals in the below sentence. I have
highlighted the correction within double quotes (") and UPPERCASE text. Does
it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/archive-recovery-settings.html
Description:
For instance for the restore command in the documentation said:
It is important for the command to return a zero exit status only if it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/libpq-pgservice.html
Description:
The default location for a user level connection service file on Windows is
not given. The path is given for the password file on the previous page in
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/libpq-pgpass.html
Description:
I kindly suggest to let me edit this part to create examples such as
pg_restore -h HOST -p PORT -U SUPERUSERNAME -C -d postgres
DBtoRESTORE.BACKUPEXTENSION
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/contrib.html
Description:
Hi All,
https://www.postgresql.org/docs/9.4/sql-createextension.html says:
"Loading an extension requires the same privileges that would be required to
create
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/collation.html
Description:
The font size of level 4 headlines (, e.g. "23.2.2.3. Creating New
Collation Objects") is remarkably smaller than the font size of level 5
headlines (, e.g.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/protocol-message-formats.html
Description:
Hi,
It would improve the readability if we add further tabulation to the
description of each message.
Also, make the message title bold to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-reindex.html
Description:
Paragraph in question:
REINDEX is similar to a drop and recreate of the index in that the index
contents are rebuilt from scratch. However, the locking
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-reindex.html
Description:
Paragraph in question:
REINDEX is similar to a drop and recreate of the index in that the index
contents are rebuilt from scratch. However, the locking
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/tutorial-join.html
Description:
Thanks for the effort for this wonderful tutorial.
The last table that illustrates joining a table on itself shows that San
Fransisco has `temp_lo`
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/functions-subquery.html
Description:
Hi.
The [DOC](https://www.postgresql.org/docs/10/static/functions-subquery.html)
says:
The result is NULL if the comparison does not
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/archive-recovery-settings.html
Description:
Documentation for restore_command in recovery.conf only says, "This
parameter is required for archive recovery, but optional for
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/runtime-config-query.html
Description:
Hi,
The effective_cache_size documentation (section 19.7) is: "When setting this
parameter you should consider both PostgreSQL's shared
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/spi-examples.html
Description:
Dear,
In the example of how to use SPI in the following link
https://www.postgresql.org/docs/10/spi-examples.html
The parameters numbers in the follow
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/install-windows-full.html
Description:
Hi I get the msg :
Unable to determine Visual Studio version: The nmake version could not be
determined. at src/tools/msvc/Mkvcbuild.pm line 91.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/sql-createschema.html
Description:
CREATE SCHEMA AUTHORIZATION joe;
the role joe must created first,than create schema authorization will
succeed
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/wal-async-commit.html
Description:
How do async commits and unlogged tables relate? You might add a paragraph
on clarifying this relation.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/indexes-partial.html
Description:
The example illustrating when a partial index can and cannot be used is a
little misleading. The query which can use the partial index is:
SELECT *
FROM
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-refreshmaterializedview.html
Description:
On 10.7 we hit a case where the backing query had an order by clause and a
concurrent refresh updated it differently than a normal refresh.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/install-windows-full.html
Description:
On the page ->
https://www.postgresql.org/docs/9.0/install-windows-full.html
My first two items are in reference to the paragraph below:
If you
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-altersystem.html
Description:
Hi,
ALTER SYSTEM can be used to set shared_preload_libraries with multiple
values in the following way.
postgres=# ALTER SYSTEM SET
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/pgupgrade.html
Description:
"For Windows users, you must be logged into an administrative account, and
then start a shell as the postgres user and set the proper path:
RUNAS
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-range.html
Description:
Hi.
It would be nice if next examples:
<< strictly left ofint8range(1,10) << int8range(100,110) t
>> strictly right of
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/datatype-numeric.html
Description:
In 8.1.4. Serial Types it says that
CREATE TABLE tablename (
colname SERIAL
);
is equivalent to
CREATE SEQUENCE tablename_colname_seq;
CREATE
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-admin.html
Description:
Hi.
Doc is not clear about what is returned if current_setting(
'app.not_existent', true ) is called.
Does it return empty string '', because return
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/install-procedure.html
Description:
If we configure build with a different prefix than the default, "make
uninstall" doesn't work. Example if i run configure as below.
1) ./configure
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/file-fdw.html
Description:
CREATE EXTENSION file_fdw;
CREATE SERVER svr_file FOREIGN DATA WRAPPER file_fdw;
CREATE FOREIGN TABLE fdt_topups (seq integer , id_user integer ,
topup_date
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/progress-reporting.html
Description:
Replace "Whenever VACUUM is running" with "Whenever AUTOVACUUM is running"
The pg_stat_progress_vacuum view does not show VACUUM run manually.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/app-pgbasebackup.html
Description:
It would be nice to see documentation over the use case of creating a backup
file with pg_basebackup when there is a linked pg_xlog directory on the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/wal-configuration.html
Description:
On the WAL Configuration page -
https://www.postgresql.org/docs/current/wal-configuration.html
It reads: "On Linux and POSIX platforms
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/rules-materializedviews.html
Description:
The examples contain ORDER BY clauses in the definition of a materialized
view. However, ORDER BY clauses do not work on materialized views
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/indexes-ordering.html
Description:
Dear Postgres team,
First, thanks for an excellent product and great documentation. This is
world class.
We have found an issue with index and ORDER BY
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/install-procedure.html
Description:
Hi,
I am a newbie to postgresql.
usually use to out of box installs like tar balls or pkg or rpm files.
I am not able to locate this.
I want to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/datatype-numeric.html
Description:
I read the doc at
https://www.postgresql.org/docs/11/datatype-numeric.html#DATATYPE-SERIAL. I
want to clarify how psql generate the sequence to existing
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/ecpg-commands.html
Description:
I have a c++ library built with libpq.so, and I am trying to run the
statements "SET AUTOCOMMIT TO ON" and "SET AUTOCOMMIT TO OFF". According to
the docs,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/jit.html
Description:
I did not see any remarks about the interaction between JIT and prepared
queries. It would be useful to document whether prepared queries benefit
from reusing JIT
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-update.html
Description:
What we have in doc:
[ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]
output_expression: An expression to be computed and returned by the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/runtime-config-wal.html
Description:
This page: https://www.postgresql.org/docs/10/runtime-config-wal.html
(And probably others in other versions) has – I believe – an error in the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql.html
Description:
Hello PostgreSQL Team,
as the title says, i couldn't find the SQL Scripts like basics.sql and
advanced.sql after creating "mydb" to test it out. There was no such
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/tutorial-accessdb.html
Description:
As you stated in the tutorial it is not working.
createdb mydb
psql mydb
the prompt of mydb is not showing.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-math.html
Description:
1) The function round( dp or numeric ) always has return type integer not
same as our parameter is.
2) The function round( dp or numeric, s int ) returns
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/release-10-4.html
Description:
I could see the features, release date are identical in version 10.4 and
9.6.9. Can you please check and this could help in choosing the right
version for
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/textsearch-debugging.html
Description:
It would be helpful if there were some documentation on how to query the
dictionaries themselves, to get a canonical root word, either.
1.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/external-pl.html
Description:
Project lives
https://github.com/postgres-plr/plr
Thanks,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/tutorial-createdb.html
Description:
I tried the first example in section 1.3 of the initial tutorial,
createdb mydb
The tutorial says
> If this produces no response then this step
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-createstatistics.html
Description:
The example on https://www.postgresql.org/docs/11/sql-createstatistics.html
seems wrong: instead of "EXPLAIN ANALYZE SELECT ..." it should say
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/config-setting.html
Description:
I noticed on this page:
https://www.postgresql.org/docs/9.6/config-setting.html
There are a few places that an include statement is made like so:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-matching.html
Description:
On https://www.postgresql.org/docs/11/functions-matching.html paragraph
9.7.3.2. Bracket Expressions says "Standard character class names are:
alnum,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-createrule.html
Description:
Hi,
It would be nice for newbies if
https://www.postgresql.org/docs/11/sql-createrule.html and
https://www.postgresql.org/docs/11/rules-update.html
are
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-conditional.html
Description:
The documentation says:
"The COALESCE function returns the first of its arguments that is not null.
Null is returned only if all arguments are
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/rangetypes.html
Description:
Hi.
May I read this:
But [today,infinity] means something different from [today,infinity) — the
latter excludes the special timestamp value infinity.
as
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/install-short.html
Description:
1)
$ mkdir /usr/local/pgsql/data
mkdir: cannot create directory ‘/usr/local/pgsql/data’: No such file or
directory
Suggested correction:
$ mkdir -p
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/ssl-tcp.html
Description:
In Section 18.9, the example showing how to create an SSL certificate:
openssl req -new -x509 -days 365 -nodes -text -out server.crt \
-keyout server.key
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/features.html
Description:
ISO/IEC 9075-2:2016
https://www.iso.org/standard/63556.html
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/functions-array.html
Description:
Hi
How do i write below native query to JPA/Hibernate. (JPQL)
SELECT * FROM TABLE_NAME WHERE TABLE_COLUMN_ARRAY && '{1,2}'
Regards,
Anand S
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/ddl-partitioning.html
Description:
In the documentation for Postgres 11 table partitioning, there is no mention
of the requirement that the Primary Key of a partitioned table must contain
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/datatype-datetime.html
Description:
In Table 8.13. Special Date/Time Inputs, the description for the special
values 'today', 'tomorrow' and 'yesterday' uses the word 'midnight' e.g. the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-syntax-lexical.html
Description:
QUOTE:
The CAST() syntax conforms to SQL. The type 'string' syntax is a
generalization of the standard: SQL specifies this syntax only for a few
data
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/datatype-datetime.html
Description:
Both sections mention syntax TIMESTAMP '2019-01-20 08:00' as valid for input
of timestamp data. This seems to work fine in psql, however, this syntax
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-set-role.html
Description:
In the course of trying to sanitise our roles and permissions I found the
notes in the SET ROLE docs a little misleading:
"If the session user role has the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/functions-string.html
Description:
Either I'm doing something wrong or the example `encode('123\000\001',
'base64')` will always result in a parsing error "string contains null
byte".
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/sql-dropprocedure.html
Description:
Hi,
I noticed that drop procedure with parenthesis doesn't work (procedure name
not found), but without parenthesis it works.
Not OK: DROP
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/functions-json.html
Description:
In Table 9-41, for 4th row(?|)
'{"a":1, "b":2}'::jsonb ?| array['b', 'c']
would be a better example to illustrate the operation of ?| than
'{"a":1,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/functions-array.html
Description:
Hi.
Noticed strange thin with @>
Query "select '{1,2}'::int[] @> '{1,2,2,2,2,2,2,2}'::int[]" returns true,
but first array contains even less elements
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/sql-select.html
Description:
The below document says that the ANALYZE statement requires a read lock.
https://www.postgresql.org/docs/current/sql-analyze.html
-
ANALYZE requires only
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/spi-spi-finish.html
Description:
Hi,
The documentation of SPI_finish clarifies that aborting with elog will
cleanup SPI automatically without need to call to SPI_finish manually, see
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/runtime-config-replication.html
Description:
Dear Sir/Madam
In the documentation concerning Replication Version 11 Standby Servers the
max_standby_streaming_delay : explanation is
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/logical-replication-config.html
Description:
I have to tune wal_sender_timeout parameter to make logical replication
stable, it might be beneficial for other users to make them aware of
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/trigger-definition.html
Description:
Hello,
documentation
(https://www.postgresql.org/account/comments/new/10/trigger-definition.html/)
says:
"A statement that targets a parent table in
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/install-short.html
Description:
i installed postgres using the the source code and by following quick
version given in the official documentation. But in the next session I am
not able to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/runtime-config-replication.html
Description:
My previous comment concerning this page
https://www.postgresql.org/docs/current/runtime-config-replication.html and
the lack of difference
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/contrib-dblink-disconnect.html
Description:
I have a function which takes one hour to complete execution.
When I submit that function to dblink_send_query, and just after 1 minute I
close
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/different-replication-solutions.html
Description:
Not sure if this is an error but I was wondering about this sentence: "In
fact, write performance is often worse than that of a single
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/contrib-dblink-connect.html
Description:
F.10. dblink is noted at top of version 11 documentation, and F.11. dblink
on version 10 documentaion. They appear to be reversed.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/ecpg-sql-connect.html
Description:
The "connection_name" parameter's explanation is not in Parameters
section.
Instead of it, "connection_object" parameter is in Parameters section. Its
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/runtime-config-wal.html
Description:
There is a link to section 30.4, it does not work.
Regards, Ernesto Silva.
101 - 200 of 949 matches
Mail list logo