Document: https://www.postgresql.org/docs/current/tutorial-sql-intro.html

2019-10-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-sql-intro.html Description: This references src/tutorial and basics.sql. Neither are available in Windows 10 install for Postgres 12.

Typo on Refresh Materialized View page

2019-10-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-refreshmaterializedview.html Description: Hello There appears to be a typo on this page: https://www.postgresql.org/docs/12/sql-refreshmaterializedview.html In the description of CON

A Rant on lock_timeout

2019-10-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/runtime-config-client.html Description: Hello, I was looking explicitly for information on the default value of lock_timeout and what it does. I got this paragraph: "Abort any statement

Invalid website links

2019-10-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/gin-intro.html Description: Chapter 66.1: "The GIN implementation in PostgreSQL is primarily maintained by Teodor Sigaev and Oleg Bartunov. There is more information about GIN on their web

grammar mistake in java8-date-time.html ?

2019-10-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/bug-reporting.html Description: I think that there's a grammar error in the following doc url: https://jdbc.postgresql.org/documentation/head/java8-date-time.html It says: "Also note that

Pls mention ERROR: 2D000: cannot commit while a subtransaction is active on this page

2019-10-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html Description: Please add a note after this sentence “A transaction cannot be ended inside a block with exception handlers.” (at the bottom of the page) thus: << I

WITH RECURSIVE (Documentation section 7.8.1) Note

2019-10-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/queries-with.html Description: In section 7.8.1, the author comments "Note: Strictly speaking, this process is iteration not recursion, but RECURSIVE is the terminology chosen by the SQL

Logical replication conflict and trying to use `pg_replication_origin_advance`

2019-09-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/logical-replication-conflicts.html Description: I have a pretty detailed setup, and can provide more details if desired, but the real issue is that I am seeing an error like the following:

Chapter 43.8. "Transaction Management" fails to state two critical restrictions

2019-09-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-transactions.html Description: This chapter fails to state: (1) If a PL/pgSQL procedure issues "commit" then it must be called with AUTOCOMMIT set to On. This is counter-intuitive

typo in 9.15. JSON Functions and Operators Table 9.46. JSON Processing Functions - alternate

2019-09-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/functions-json.html Description: sorry, the last message may have been incorrect. if so, the next row in table 9.46 should be changed from: jsonb_insert(target jsonb, path text[],

typo in 9.15. JSON Functions and Operators Table 9.46. JSON Processing Functions

2019-09-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/functions-json.html Description: In the 'Function' column of Table 9.46: jsonb_set(target jsonb, path text[], new_value jsonb[, create_missing boolean]) should be jsonb

default_tablespace and parallel queries

2019-09-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/manage-ag-tablespaces.html Description: Hi, "default_tablespace" parameter in "postgresql.conf" does something to GATHER (in parallel query). Because when default_tablespace is set to wh

Logical replication restriction documentation

2019-09-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/logical-replication-restrictions.html Description: Re this note in the "logical replication restrictions" documentation page: Replication is only possible from base tables to base tables.

I'm surprised to see the word master here

2019-09-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/logical-replication-publication.html Description: I was under the impression we were removing the use of that word from our docs ?

returning does not act as expected after viewing documentation

2019-09-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/dml-returning.html Description: With the following query: update batch_log set status=('in-progress'), updated_at=now() where status = ('pending') and id = ( select id from batch_log

Do not use C++ style comments (// comments). Strict ANSI C compilers do not accept them.

2019-09-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/source-format.html Description: This sentence in the style guide feels outdated. // style comments have been in the ANSI C standard for almost 20 years now (C99 was accepted as ANSI standa

invalid ldconfig [option]

2019-09-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/install-post.html Description: In the line "/sbin/ldconfig -m /usr/local/pgsql/lib" the "-m" is a invalid option. I think is a mispelling of a "-n" option. Best Regards umbo

dblink version noted at top of documentation

2019-09-18 Thread PG Doc comments form
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.

About limitation characters in ECPG's connection string

2019-09-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/ecpg-sql-connect.html Description: Please add the note about the limitation characters in connection string. For example, I think that below explanation should be in the Parameter section

Is it typo of connection_name?

2019-09-17 Thread PG Doc comments form
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 ex

Synchronous Multimaster Replication

2019-09-16 Thread PG Doc comments form
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 ser

query sent to dblink_send_query and close the connection

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

Bad link in Postgres 11 documentation - 19.5 WAL

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

Reference tables in triggers are supported in 10

2019-09-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/infoschema-triggers.html Description: The documentation states the following: action_reference_old_table sql_identifier Applies to a feature not available in PostgreSQL action_refer

Please add example

2019-09-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/functions-formatting.html Description: On this screen: https://www.postgresql.org/docs/11/functions-formatting.html Please consider adding this as an example: to_char( (now()-INTERVAL '10

uniqueness and null could benefit from a hint for dba

2019-09-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/indexes-unique.html Description: Sometimes it is convenient to create an unique index that considers NULL values equal. Designating a "zero" value for those rows might not be feasible, for

Syntax incorrect for psql 9.6

2019-09-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.4/sql-reindex.html Description: For the REINDEX DATABASE command, the documentation suggests REINDEX DATABASE databaseName, however my experience suggests this does not work; the database n

installation

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

Truncate statement-level trigger behaviour

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

potentially missing reference to wal_sender_timeout

2019-08-22 Thread PG Doc comments form
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 th

incorrect revision - my apologies

2019-08-21 Thread PG Doc comments form
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 ab

max_standby_streaming_delay : explanation is repeated directly after first explanation

2019-08-21 Thread PG Doc comments form
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 repeated

Server Configuration: Replication documentation

2019-08-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/runtime-config-replication.html Description: The description Terminate replication connections that are inactive longer than the specified number of milliseconds. could be confusing to s

SPI_finish in the case of ereport

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

Required locks for ANALYZE

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

@> (contains)

2019-08-18 Thread PG Doc comments form
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 th

Wrong drop procedure example

2019-08-16 Thread PG Doc comments form
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 PROCEDURE

Better Example

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

any() and ilk wrt to what they accept

2019-08-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/functions-comparisons.html Description: I recently wanted to do something like "not($col like all($subquery_that_returns_multiple_values))" but wasted quite a bit of time trying to debug w

Is it wise to include table inheritence in the tutorial?

2019-08-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/tutorial-inheritance.html Description: Hello, I was reading the tutorial here: https://www.postgresql.org/docs/11/tutorial-inheritance.html But on the "don't do this" Wiki, it is strongl

Example of creating subscription for publications in the same cluster

2019-07-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-createsubscription.html Description: This page: https://www.postgresql.org/account/comments/new/10/sql-createsubscription.html/ explains that the CREATE SUBSCRIPTION command would hang

pg_upgrade "configdir" vs "datadir"

2019-07-29 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: pg_upgrade seems to assume that the datadir and the configdir are the same but on Debian/Ubuntu they are not the same by default (installing from the postgres r

Improvements regarding explanation of parallel execution and detailed node parameters

2019-07-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/using-explain.html Description: Proposals for improvement of EXCPLAIN docu https://www.postgresql.org/docs/current/using-explain.html: 1. There is no mentioning of how parallel execution g

Missing preposition 'of'

2019-07-25 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: By the end of section 7.2.1.5, the preposition 'of' is missing: "(...) we could find out which ones those are like this: (...)" should read "(..

Wrong formatting of the word 'executed'

2019-07-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/plpgsql-expressions.html Description: In section 43.4, in the sentence "(...) and then this prepared statement is EXECUTEd (...)", the word executed should be modified to lower case.

User mapping security

2019-07-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/postgres-fdw.html Description: Regarding the documentation pages https://www.postgresql.org/docs/10/postgres-fdw.html?origin_team=T02HEPYKQ and https://www.postgresql.org/docs/10/sql-creat

Ambiguous language in Table 8.13. Special Date/Time Inputs

2019-07-08 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: 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 sp

Postgres 11: Table Partitioning and Primary Keys

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

Documentation about physical replication

2019-07-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/warm-standby.html Description: I think it would be a good idea if the chapter about replication (https://www.postgresql.org/docs/current/high-availability.html) clearly stated that physica

Non working example

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

RESET does not work as described

2019-06-27 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: The initial value returned when current_setting() is passed an unset parameter is ''. After a SET and a RESET, the value returned by current_setting() is '

postgresql.conf

2019-06-19 Thread PG Doc comments form
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: include

More obvious clarification is needed about how RLS interacts with views

2019-06-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createpolicy.html Description: It's not clear enough from reading the documentation on RLS security policy that schema designers need to pay special attention to views and their owners

Mistake in documentation for CREATE STATISTICS

2019-06-13 Thread PG Doc comments form
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 "EXPLA

Unexplained createdb mydb response

2019-06-05 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: 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 was

error: unrecognized privilege: 39 sql state: xx000

2019-05-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/infoschema-columns.html Description: Whats is wrong? I cant get information from information_schema.columns like from information_schema.tables. Version: 10.4

Character classes

2019-05-20 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: On https://www.postgresql.org/docs/11/functions-matching.html paragraph 9.7.3.2. Bracket Expressions says "Standard character class names are: alnum, a

Documentation bug

2019-05-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/sql-createfunction.html Description: In the documentation https://www.postgresql.org/account/comments/new/9.6/sql-createfunction.html/ (and in the same document for earlier versions) the

Minor improvement for creating directory structure

2019-05-08 Thread PG Doc comments form
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 /usr/lo

Latest ISO is 2016, not 2011

2019-05-06 Thread PG Doc comments form
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

intarray overlap (have elements in common) operator

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

suggestion: "See also" for create rule and Rules on INSERT, UPDATE, and DELETE

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

Why 'infinity' is not in range '[2019-01-02, infinity]'?

2019-04-29 Thread PG Doc comments form
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 B

COALESCE doccumentation

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

cube grouping

2019-04-25 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: in the above example it seems as though the result CUBE(a,(b,c),d) GROUPING SETS ( ( a, b, c, d ), ( a, b, c), ( a ),

SET ROLE documentation not entirely correct

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

SSL string

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

PL/R points to wrong place

2019-04-15 Thread PG Doc comments form
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,

question concerning tutorial.sql

2019-04-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/tutorial-sql-intro.html Description: Hi, How can I find and load .sql files needed for the tutorial? Can I expect to find them in postgress 11? If so, what map? Thanks, Francis

Typo

2019-04-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createfunction.html Description: I have noted that it seems not convenient. " Writing SECURITY DEFINER Functions Safely " https://www.postgresql.org/docs/11/sql-createfunction.html

self join

2019-04-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/tutorial-join.html Description: The example of self join shows two resulting records. I have checked the input data. There are three output records with lower lo and higher high temperatu

JOINS example

2019-04-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/tutorial-join.html Description: The data is incomplete for results on all possible joins, given as an exercise. Help the student by introducing a temporary fake city, with no matching wea

Section 4.1.2.7 contains false information

2019-04-09 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: 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 t

Confusing information in sections 8.5 and 9.9 (date and time types, functions and operators)

2019-04-09 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: 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 ca

How to query the underlying dictionary i.e. inverse of ts_lexize()

2019-04-07 Thread PG Doc comments form
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. Directly,

Building Source from windows clarification

2019-04-04 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: 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 wish

REFRESH MATERIALIZED VIEW CONCURRENTLY interaction with ORDER BY

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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_

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

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

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

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

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

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

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

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

<    4   5   6   7   8   9   10   11   12   >