Extend example of JOIN results for completeness

2018-09-08 Thread PG Doc comments form
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 RI

Extend phrase by an example

2018-09-09 Thread PG Doc comments form
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 a

please inform data_directory

2018-09-09 Thread PG Doc comments form
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

join tutorial: table joined on itself

2018-09-13 Thread PG Doc comments form
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` l

effective_cache_size

2018-09-13 Thread PG Doc comments form
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 buff

Ambiguous usage of 'any' in explanation

2018-09-15 Thread PG Doc comments form
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 retu

Ambiguity in restore_command for recovery.conf

2018-09-18 Thread PG Doc comments form
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 streamin

Punctuation error

2018-09-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/logical-replication-publication.html Description: This sentence should not use a semicolon: "Both the ADD TABLE and DROP TABLE operations are transactional; so the table will start

dblink_get_result returns NULL if remote query throws error

2018-09-25 Thread PG Doc comments form
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 you

Incorrect description of autovacuum_vacuum_threshold and autovacuum_vacuum_scale_factor

2018-09-27 Thread PG Doc comments form
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 independently

pgrowlocks columns do not match docs: "modes" instead of "lock_type"

2018-10-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/pgrowlocks.html Description: Hi, The description of the pgrowlocks extension says that the function returns a column called "lock_type". However this column is really called "modes

Alter table says rewrite is required for default values on 11.

2018-10-09 Thread PG Doc comments form
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 added,

type point

2018-10-16 Thread PG Doc comments form
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 is

CURSOR WITH HOLD does not state the memory/disk implications

2018-10-17 Thread PG Doc comments form
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

CREATE PROCEDURE Documentation

2018-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/static/sql-call.html Description: In the documentation for the CALL statement, it is mentioned that PROCEDUREs are capable of executing transaction-control statements. I think the CREATE P

The DROP TABLE instruction should have a TEMP option for when a temporary table

2018-10-19 Thread PG Doc comments form
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

INSERT INTO RETURNING SYNTAX ERROR

2018-10-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/static/sql-insert.html Description: When using the RETURNING extension on the INSERT function when nested, does not propagate the return value up, and causes a syntax error on the "INTO"

Documentation for create unique index is insuficient and (because of that) incorrect

2018-10-23 Thread PG Doc comments form
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 https://www.

COPY on partitioned table

2018-10-24 Thread PG Doc comments form
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 reasons

Phrasing to consider (non-technical)

2018-10-30 Thread PG Doc comments form
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 soft

ALTER SERVER SYNTAX ISSUE

2018-10-31 Thread PG Doc comments form
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

Tipos de datos enteros

2018-11-01 Thread PG Doc comments form
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

tables (and other objects) are automatically put into a schema named "public"

2018-11-08 Thread PG Doc comments form
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 g

The 'replication' keyword

2018-11-10 Thread PG Doc comments form
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 dat

Create Table documentation, version 10 - Examples

2018-11-10 Thread PG Doc comments form
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 "t

Add NOTICE about non-NFC-characters and clues for solution

2018-11-16 Thread PG Doc comments form
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 p

missing windows info

2018-11-19 Thread PG Doc comments form
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

Add note about how to disable the subscription too?

2018-11-19 Thread PG Doc comments form
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. In

CREATE/ALTER ROLE with NULL password

2018-11-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-alterrole.html Description: When creating a role with no password, or altering a role to remove its password, the ENCRYPTED clause must not be present. The current synopsis for CREATE

In unquoted identifiers, only single-byte characters are always folded to lower case

2018-11-23 Thread PG Doc comments form
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 yo

Need for

2018-11-23 Thread PG Doc comments form
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 `plpy.execute('

typo

2018-11-25 Thread PG Doc comments form
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 so

Return codes for archive and restore commands

2018-11-28 Thread PG Doc comments form
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 succee

Objects without schema

2018-11-29 Thread PG Doc comments form
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 all.'

More clarification on createdb command

2018-12-02 Thread PG Doc comments form
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 sm

More clarification on createdb command

2018-12-02 Thread PG Doc comments form
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 sm

Minor typo in sentence

2018-12-06 Thread PG Doc comments form
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 af

Broken link in Appendix H.3

2018-12-07 Thread PG Doc comments form
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 http://python.projects.postgresql.org/b

citext plugin is not working with java applications

2018-12-10 Thread PG Doc comments form
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

Undocumented behaviour of \s in SIMILAR TO expression

2018-12-13 Thread PG Doc comments form
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 escap

pgBadger link needs to be updated

2018-12-13 Thread PG Doc comments form
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/

Error in example

2018-12-19 Thread PG Doc comments form
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 lin

Need clarification on how to extract or compare numeric values enclosed in jsonb

2018-12-19 Thread PG Doc comments form
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 https://stackoverflow.com/questio

The documentation on Partitions does not document the DEFAULT partition

2018-12-21 Thread PG Doc comments form
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 part

Re:Upgrading a PostgreSQL Cluster Documentation

2018-12-22 Thread PG Doc comments form
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 i

Mistyped message severity

2018-12-26 Thread PG Doc comments form
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, DEBUG1

Possible edit slip in Architecture Fundamentals.

2019-01-02 Thread PG Doc comments form
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 Fundamentals(https://www.postgresql.org/d

Broken link in JSON Types documentation

2019-01-02 Thread PG Doc comments form
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 http

Documentation sections does not match exactly

2019-01-08 Thread PG Doc comments form
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 i

protocol-message-formats <- display format

2019-01-09 Thread PG Doc comments form
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 visua

REINDEX locking behavior seems inconsistent with the documentation

2019-01-09 Thread PG Doc comments form
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 consid

REINDEX locking behavior seems inconsistent with the documentation

2019-01-09 Thread PG Doc comments form
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 consid

.pgpass

2019-01-10 Thread PG Doc comments form
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

Font size of nested headlines counterintuitive

2019-01-11 Thread PG Doc comments form
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. "23

DOC not so clear

2019-01-14 Thread PG Doc comments form
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 r

Clarify behaviour of ADD COLUMN for partitioned tables

2019-01-15 Thread PG Doc comments form
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 will

MULE_INTERNAL

2019-01-16 Thread PG Doc comments form
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 'MULE_INTER

Ambiguous description for "Index Storage Parameters" section for Create index chapter

2019-01-17 Thread PG Doc comments form
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 B

majord...@postgresql.org: unknown address

2019-01-17 Thread PG Doc comments form
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.".

1.3. Creating a Database (on Windows) - User Experience

2019-01-21 Thread PG Doc comments form
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 doe

couldn't find the tutorial sql's

2019-01-25 Thread PG Doc comments form
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 fo

build on windows issue - running build.bat from src\tools\msvc

2019-01-26 Thread PG Doc comments form
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. Th

Not working

2019-01-31 Thread PG Doc comments form
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.

Round(DP Or numeric ) returns integer

2019-01-31 Thread PG Doc comments form
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 t

Release Notes for PostgreSQL v10.4 is same as release 9.6.9

2019-01-31 Thread PG Doc comments form
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 an

What does the value 5874897 AD mean? Which year, month, day, please?

2019-02-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/datatype-datetime.html Description: See also https://stackoverflow.com/questions/29434748/what-does-bc-date-mean-in-postgresql. Add a note about how the date/timestamp is internally repre

Typo in Table 8.7 bytea Literal Escaped Octets

2019-02-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/datatype-binary.html Description: In "Table 8.7. bytea Literal Escaped Octets", the backslash character should be escaped as '\\' or '\134', not '\' or '\\134'. https://www.postgresql.org

Statement-level Triggers

2019-02-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createtrigger.html Description: The behaviour is not clear for BEFORE Statement-level Trigger. This is because transition tables cannot be used. So how does one get access to the rows

Statement-level Triggers

2019-02-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createtrigger.html Description: The AFTER Statement-level Trigger runs into infinite execution when another set of rows are affected for the same table through this trigger. Consider t

AutoCommit statements do no work with postgresql 11.

2019-02-08 Thread PG Doc comments form
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,

Incorect path

2019-02-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/tutorial-sql-intro.html Description: At https://www.postgresql.org/docs/9.4/tutorial-sql-intro.html it is written: $ cd /src/tutorial $ make --- $ cd /tutorial $ psql -s mydb The

New vs old values collision in UPDATE RETURNING docs

2019-02-15 Thread PG Doc comments form
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 UP

Typo in documentation - runtime-config-wal

2019-02-16 Thread PG Doc comments form
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 descrip

JIT and prepared queries

2019-02-16 Thread PG Doc comments form
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 out

pg_upgrade

2019-02-19 Thread PG Doc comments form
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 /USER:postgre

Update to equivalent SQL in 8.1.4. Serial Types

2019-02-20 Thread PG Doc comments form
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 TAB

Improve documentation for current_setting function

2019-02-20 Thread PG Doc comments form
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 typ

Improve examples for range operators

2019-02-20 Thread PG Doc comments form
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 int8ran

HEADER [ boolean ] not allowed in COPY ... FROM statement

2019-02-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-copy.html Description: > psql --version ; psql (PostgreSQL) 11.2 > initdb --version ; initdb (PostgreSQL) 11.2 The boolean parameter is not allowed in the statement: # COPY table_nam

FORMAT keyword not allowed in COPY ... FROM statement

2019-02-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-copy.html Description: > psql --version ; psql (PostgreSQL) 11.2 > initdb --version ; initdb (PostgreSQL) 11.2 # \h copy Command: COPY Description: copy data between a file and a

Postgres make uninstall

2019-02-22 Thread PG Doc comments form
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 --pr

Using file_fdw to load tsv file into Foreign Table gives Permission denied error

2019-02-23 Thread PG Doc comments form
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 da

With statements does not modify original table untill it is "complete"

2019-02-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/queries-with.html Description: I think it should be more more visible that data does not change in the table, untill the with statement is complete. It took some trial-and-error and fine-r

Error in 9.6 documentation? checkpoint_flush_after

2019-03-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/runtime-config-wal.html Description: https://www.postgresql.org/docs/9.6/runtime-config-wal.html 19.5.2 checkpoint_flush_after (integer) Whenever more than checkpoint_flush_after by

pg_basebackup of local postgres with linked pg_xlog directory

2019-03-08 Thread PG Doc comments form
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 loc

WAL Configuration Grammar Fix

2019-03-08 Thread PG Doc comments form
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 checkpoint_flush_

Serial Data type

2019-03-12 Thread PG Doc comments form
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

28.4.1. VACUUM Progress Reporting

2019-03-14 Thread PG Doc comments form
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. Thanks

order by in materialized views

2019-03-19 Thread PG Doc comments form
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 after

ORDER BY LIMIT n does not work as described when using partitioned tables

2019-03-20 Thread PG Doc comments form
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

how to install postgresql

2019-03-20 Thread PG Doc comments form
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 i

REASSIGN OWNED command page is not clear regarding to DEFAULT PRIVILEGE objects.

2019-03-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-reassign-owned.html Description: Hi, Recently I try to drop a role without affecting objects dropped owned by it, and try to use REASSIGN OWNED command to transfer ownership. But we f

CREATE SCHEMA AUTHORIZATION joe;

2019-03-27 Thread PG Doc comments form
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

30.3. Asynchronous Commit

2019-03-27 Thread PG Doc comments form
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. https://www.postgresql.org/docs/9.6/wal-async-c

Please add one more ALTER SYSTEM command example

2019-03-28 Thread PG Doc comments form
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 shared_preload_librar

error

2019-03-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/xfunc-sql.html Description: > hello > > i've descovered a small error - instead of integer should be numeric > > https://www.postgresql.org/docs/9.6/xfunc-sql.html > > CREATE FUNCTION

Missing pg_seetings catalog name in table 49.1

2019-04-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.5/catalogs-overview.html Description: Table 49.1 on https://www.postgresql.org/docs/9.5/catalogs-overview.html list system catalog. pg_seetings is not listed in the table.

bgwriter_lru_multiplier maximum value

2019-04-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/runtime-config-resource.html Description: The server has an undocumented maximum value of 10 for bgwriter_lru_multiplier, and will fail to start if it's set higher than this: LOG: 20 is

Small mistake (grammar/wording)

2019-04-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/libpq-exec.html Description: Hi, just found a small mistake in https://www.postgresql.org/docs/current/libpq-exec.html (Version 11 Chapter 34.3), the sentence that starts with "Note that

Clarity in partial index example.

2019-04-03 Thread PG Doc comments form
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 a

<    1   2   3   4   5   6   7   8   9   10   >