The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/pgupgrade.html
Description:
If a reader who is unfamiliar with PostgreSQLs versioning (where 9.5 and
9.6 are considered major versions) reads the documentation, it is unclear if
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/sql-altertable.html
Description:
Missing column_constraint explanation in parameters section
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-syntax.html
Description:
I didnt see documentation in postgresql title
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/sql-select.html
Description:
In the SELECT statement page the argument type of the (FOR SHARE/UPDATE) OF
clause is listed to be a table_name. This is not *quite* accurate - it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/7.1/static/functions-math.html
Description:
The last row of table Table 4-4. Mathematical Functions seems to be wrong at
example column, current value
trunc(numeric, s integer)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/errcodes-appendix.html
Description:
Hi
Would it be possible to present the codes in ascending sequence?
This applies to all releases.
Thanks
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/app-psql.html
Description:
While I get that we want alphabetical order an exception for \i and \ir
seems warranted; or maybe make \ir part of the \i meta command description -
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/functions-json.html
Description:
Hi team,
I had the following issue when going through your
https://www.postgresql.org/docs/current/static/functions-json.html docs.
Looking at
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/pgstatstatements.html
Description:
At the top of the pg_stat_statements docs page[1] it states:
"The pg_stat_statements module provides a means for tracking execution
statistics
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/queries-limit.html
Description:
The documentation of the SELECT statement lists FETCH FIRST/OFFSET as an
alternative to the proprietary LIMIT clause.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/libpq.html
Description:
Hello,
I am not sure if I am doing something wrong or there is a bug in the code
but I am getting a strange issue. When I try to run the following code I
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/tutorial-sql.html
Description:
where is ALTER?
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/queries.html
Description:
try checking your XML syntax. missing attribute?
The following documentation comment has been logged on the website:
Page:
https://www.postgresql.org/docs/10/static/logical-replication-publication.html
Description:
In section 31.1 it says "A publication is a set of changes generated from a
table or a group of tables"... that seems wrong. It's
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/protocol-message-formats.html
Description:
On this page:
https://www.postgresql.org/docs/10/static/protocol-message-formats.html
The documentation says:
For a SELECT or CREATE
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/ecpg-sql-set-autocommit.html
Description:
Hi,
I am currently using PG10, and link my C program to the libpq.5.10.so file
for client feature usage.
I get the following error after
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/logical-replication.html
Description:
I am referring to link
'https://www.postgresql.org/docs/10/static/logical-replication.html' and it
has been mentioned that 'Replicating
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/typeconv-union-case.html
Description:
Hi!
Whilst the type conversion works great on the query ;select 10 as col1 union
select null as col1;, it does not on the almost same one
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/static/functions-string.html
Description:
https://www.postgresql.org/docs/9.4/static/functions-string.html
in the overlay example, there should only be 'xxx' instead of ''. (the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/sql-altertable.html
Description:
I see references to a "table rewrite" all over the place, but I cannot find
one single definition on what that actually means.
What does a table
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/devel/static/app-pg-ctl.html
Description:
The docs for --wait still say:
"When waiting for startup, pg_ctl repeatedly attempts to connect to the
server."
I believe it's been changed to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/tutorial-sql.html
Description:
Programação Java
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/pgupgrade.html
Description:
In set 9. Run pg_upgrade:
It says that windows users should execute this:
RUNAS /USER:postgres "CMD.EXE"
This step does not work unless you create a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/sql-keywords-appendix.html
Description:
Hello, my client has a plethora of reserved words in their PostgreSQL
database using Greenplum. They don't wish to use the " " to allow
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/encryption-options.html
Description:
Section "18.8. Encryption Options" only mentions MD5 as the password storage
encryption mechanism, although PostgreSQL 10 introduced the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/gin-intro.html
Description:
fff
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/infoschema-applicable-roles.html
Description:
The documentation for applicable_roles says: "The current user itself is
also an applicable role." (see
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-keywords-appendix.html
Description:
Hi,
Some people developing code formatting/highlighting plugins use this table
as the list of PostgreSQL key words:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/queries-union.html
Description:
I believe that the documented behavior of EXCEPT is not in agreement
with Postgres behavior (I'm using Postgres 9.5). The documents say:
EXCEPT
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/functions-json.html
Description:
with the prior experience of mysql or mongoDb or any other. Documentation
can be understood. But without any experience of those, hard to try the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.2/static/plpgsql-trigger.html
Description:
.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/runtime-config-connection.html
Description:
Engineering The Future
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/queries-order.html
Description:
This works:
select distinct o.bid, organisation, posttown, replace(case when phone =''
then null else trim(phone) end, ' ', ''), phone, o.active,
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/7.0/static/security.htm
Description:
Learning PostgreSQL
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.1/static/contrib-dblink-function.html
Description:
There is no information about what permissions should be setup for the user
who wants to query a database through a dblink. Thank you to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/sql-prepare-transaction.html
Description:
Under PREPARE TRANSACTION it says that transaction_id must be unique, it
doesn't say what happens when it is not unique.
It might be
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/pltcl-overview.html
Description:
Good morning,
I already installed postgreSQL v:9.5 on my PC and I want to install pltcl
language to write external procedure that are used to copy
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/8.1/static/backup.html
Description:
Greetings,
My name is Jorge Castro, I am an support engineer from Google Cloud Premier
Partner in Mexico, we have a potencial client which uses your
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/8.3/static/auth-pg-hba-conf.html
Description:
My pg_hba.conf file gives 'cert' as an authentication method. this is not
mentioned on this page.
I think a basic pg_hba.conf to allow remote
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/postgres-fdw.html
Description:
The examples about postgres_fdw do not tell about the need to have a HANDLER
when we want to access foreign tables. There should be indications on
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-createtable.html
Description:
See the example from the documentation for CREATE TABLE below. There should
be a comma before the CONSTRAINT keyword.
CREATE TABLE distributors
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/view-pg-hba-file-rules.html
Description:
Hi,
According to the documentation, I assume normal users will be able to view
pg_hba_file_rules once they are granted select privileges.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.1/static/backup.html
Description:
I am Rolycore
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/tutorial-start.html
Description:
test
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/app-pg-dumpall.html
Description:
The example to dumb all databases at the bottom of the page pg_dumpall
db.out works, but I think it would be better to suggest pg_dumpall
-f
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/0.0/static/docguide-toolsets.html
Description:
In J.2.3 Debian Packages
"docbook" and "dbtopub" missed in install command.
make world works after above to package installed.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/ddl-schemas.html
Description:
cite
5.8.3. The Schema Search Path
There is nothing special about the public schema except that it exists by
default.
end cite
It's not true. Also
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html
Description:
https://www.postgresql.org/docs/10/static/libpq-pgpass.html
$ dpkg -l | grep -i postgres
ii libpq5:amd64
The following documentation comment has been logged on the website:
Page:
https://www.postgresql.org/docs/10/static/contrib-dblink-error-message.html
Description:
Documentation says:
Return Value
Returns last error message, or an empty string if there has been no error in
this connection.
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/plpython-sharing.html
Description:
Page https://www.postgresql.org/docs/10/static/plpython-sharing.html says:
"The global dictionary SD is available to store data between function
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/queries-with.html
Description:
Hi. I have found
[DOC](https://www.postgresql.org/docs/10/static/queries-with.html)
it is fine, but did not cover multiple WITH in one query.
I
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-prepare.html
Description:
The backend protocol limits the number of parameters that can be passed for
a prepared statement to 32767 (2 byte signed integer).
As that is
The following documentation comment has been logged on the website:
Page:
https://www.postgresql.org/docs/9.6/static/sql-set-session-authorization.html
Description:
https://www.postgresql.org/account/comments/new/9.6/sql-set-session-authorization.html/
You should also mention necessary rights
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/datatype-numeric.html
Description:
In table 8.2 for numeric types, when the documentation states "6 decimal
digits precision" for the real type, we are talking about 6 digits after
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-prepare.html
Description:
Background can be found on the bugs list (pgsql-bug #15289). It was
explained that when a prepared statement parameter needs to have its type
inferred
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/disk-usage.html
Description:
PostgreSQL 9.5.14 Documentation / Chapter 28. Monitoring Disk Usage / 28.1.
Determining Disk Usage
(Applies for other Versions, too.)
I'm wondering
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/queries-table-expressions.html
Description:
Hi
The section:
https://www.postgresql.org/docs/10/static/queries-table-expressions.html#QUERIES-FROM
shows result of INNER, LEFT and
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/rowtypes.html
Description:
Hi.
On the page:
https://www.postgresql.org/docs/10/static/rowtypes.html
>then the same inventory_item composite type shown above would come into
being
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/functions-admin.html
Description:
It is impossible to use pg_read_file(), etc. functions without
SHOW data_directory
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-createtable.html
Description:
Hi.
https://www.postgresql.org/docs/current/static/sql-createtable.html#sql-createtable-exclude
If all of the specified operators test for
The following documentation comment has been logged on the website:
Page:
https://www.postgresql.org/docs/10/static/multivariate-statistics-examples.html
Description:
Hi All,
I'm a little confused by the documentation here:
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/ddl-partitioning.html
Description:
Why in provided samples of "insert" triggers on partitioned table at the end
of the triggers you provide "return NULL" not "return NEW"?
This
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-expressions.html
Description:
Documentation for PostgreSQL 10.4
4.2.7. Aggregate Expressions
...
aggregate_name (expression [ , ... ] [ order_by_clause ] ) [ FILTER ( WHERE
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/app-pgrestore.html
Description:
Hi Team,
The documentation for pg_restore doesn't mention the syntax to restore from
a directory based back up created using -F d option in
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.5/static/sql-altertype.html
Description:
I need to add a value to an enum, so I found this page, which answered my
question. However, I found it quite confusing that it only documents
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-select.html
Description:
The SYNOPSIS section of the "SELECT" SQL command contains the line
[ { UNION | INTERSECT | EXCEPT } [ ALL | DISTINCT ] select ]
(with a boldface
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/pgupgrade.html
Description:
The postgresql service (since 9.x?) runs under Windows with the integrated
NetworkService account and not with a dedicated postgres account anymore (at
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/ltree.html
Description:
Hi,
https://www.postgresql.org/docs/current/static/ltree.html links to
www.dmoz.org which now returns a 403, since being closed down in 2017.
Maybe it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/functions-json.html
Description:
the documentation is missing some information
how does the jsonb_set function work?
does it create a whole new json and updates it in the column?
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/features.html
Description:
CSV files can be huge. most commercial spreadsheets cannot handle it. there
are high-volume transactions such as for tax reporting which need a separate
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/libpq.html
Description:
It should be mentioned, that the function PQfmod is not applicable for a
valid PGresult returned by PQdescribePrepared.
PQfmod delivers additional
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.0/static/tutorial-createdb.html
Description:
I'm new to PostgreSQL and following the getting started guide. I expected it
to start from zero, but it assumes the reader already has a
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/functions-array.html
Description:
In table 9.49
(https://www.postgresql.org/docs/10/static/functions-array.html#ARRAY-FUNCTIONS-TABLE)
there is an extra comma in the syntax for
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/server-start.html
Description:
PostgreSQL user
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/static/server-start.html
Description:
OpenBSD 6.1 i386
PostgreSQL 9.6
In Section 18.3. Starting the Database Server, I did something different
from the documentation. Instead of editing
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/auth-pg-hba-conf.html
Description:
pg_hba.conf requires a list of supported subnets that can be usedsuch as 0,
12, 16, 20, 24, 32, 64.
note that 32 doesn't work as our
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/auth-pg-hba-conf.html
Description:
setting pg_hba.conf with any of the example connection securty types, its
states that the connection couldn't be use when setting "trust"
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/cube.html
Description:
student
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/plpgsql-trigger.html
Description:
The documentation (10 and 9.6) contains a typo when mentioning 'Special
local variables PG_something'. Instead it should be 'Special local
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/tutorial-start.html
Description:
document
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/functions-json.html
Description:
The json_populate_record and json_populate_recordset functions have an extra
optional undocumented boolean parameter. According to
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/tutorial-install.html
Description:
prog
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/textsearch-features.html
Description:
Hello,
In some queries there is an extra indentation. For example:
SELECT to_tsquery('fat') <-> to_tsquery('cat | rat');
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/tutorial-install.html
Description:
PostgreSQL Ok
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/static/datatype-geometric.html
Description:
I think that the information on points should contain a sentence like this:
"Order is Longitude, Latitude - so if you plot it as the map, it
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-declare.html
Description:
CURSOR WITH HOLD will consume memory and or disk
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.3/static/sql-createtable.html
Description:
Hi,
There is an obvious "issue" with temporary tables.
Case description:
We have a public table public."myTooImportantTable"
Then you have
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/static/indexes-unique.html
Description:
In https://www.postgresql.org/docs/11/static/indexes-unique.html there are
omited clausules
For example WHERE clausule is omited.
In
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/static/ddl-partitioning.html
Description:
"If you want to use COPY to insert data, you'll need to copy into the
correct child table rather than directly into the master."
What the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/sql-alterserver.html
Description:
I found that the alter server statement below does not work:
ALTER SERVER foo OPTIONS (host 'foo', dbname 'foodb');
but this does:
ALTER SERVER
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/static/datatype.html
Description:
Por favor, seria posible incluir el tipo de datos TINYINT, Es el tipo de
datos numérico más chico dentro del lenguage SQL, y su utilización siendo
escasa
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/static/datatype-datetime.html
Description:
On the page for Data Types - DateTime, there is this part of a sentence:
"so the same time zone names are also recognized by much other
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/auth-pg-hba-conf.html
Description:
I've been setting up logical replication today and I had a lot of trouble
getting it to work. The main issue I ran into was that I mistakenly had the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/sql-createtable.html
Description:
I feel there should be an example of creating a table with a foreign key,
since it is pretty common.
Here is a suggestion which follows the established
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/11/unaccent.html
Description:
Seems a bug, because the `select unaccent('Iglésias')` result in accented
"iglésias" again... It is correct because length('Iglésias') is 9 instead
8.
The
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.6/ddl-schemas.html
Description:
This statement is not true and is contradicted in
https://www.postgresql.org/docs/9.6/sql-createtable.html which states
correctly that:
If a schema name is
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/ddl-alter.html
Description:
https://www.postgresql.org/account/comments/new/11/ddl-alter.html/
indicates that the table needs a rewrite when a column with a default value
is
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/runtime-config-autovacuum.html
Description:
This page lists the different autovacuum options. Describing
autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/role-membership.html
Description:
https://www.postgresql.org/docs/10/static/role-membership.html
it says
"Once the group role exists, you can add and remove members using the
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/10/static/index.html
Description:
for a beginner, your documentation is hard to follow. nowhere does it
discuss how to create a user that have "createdb" and "createrole"
privileges. you
1 - 100 of 942 matches
Mail list logo