More explicit documentation neede on "pgpass"

2022-10-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/libpq-pgpass.html Description: The subdirectory of $APPDATA$ should be stated explicitly in the documentation. The choices are "\AppData\Local", "\AppData\LocalLow", and "\AppData\Roaming"

update

2022-10-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-update.html Description: the syntax used for update is a bit incorrect if the syntax used as it is mentioned in the site then the update will be done only to the last row in the t

request clarification on pg_restore documentation

2022-09-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/app-pgrestore.html Description: pg_restore seems to have two ways to restore data: --section=data or --data-only There is this cryptic warning that --data-only is "similar to but for

PostgreSQL source distribution files

2022-09-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-sql-intro.html Description: Section 2.1: https://www.postgresql.org/docs/current/tutorial-sql-intro.html "Examples in this manual can also be found in the PostgreSQL source distr

How to access a database in the pgadmin UI

2022-09-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-accessdb.html Description: I have a database that doesn't visualize in the pgadmin UI although I can see this DB in my terminal by executing the right commands.

Do blocks support transaction control?

2022-09-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-do.html Description: Apparently now DO blocks support COMMIT; - which make them more like procedures than functions. Tried it with: create table z (a int4, b int4); insert into z (a,

Documentation on pgdump(1) uses "regular expression" instead of "psql pattern"

2022-09-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/app-pgdump.html Description: Hello. the [1] uses term "regular expression" where "psql pattern" [2] should be used instead which may be misleading (and might cause even some harm in some

Extension-specific version release notes?

2022-09-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/citext.html Description: I'm having difficulty finding version difference information about native extensions. For instance, I have an instance running citext version 1.1 and an update com

error on „ 38.5. Query Language (SQL) Functions“: a single row is returned

2022-09-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/xfunc-sql.html Description: On the page „ 38.5. Query Language (SQL) Functions“ below the example CREATE FUNCTION new_emp() RETURNS emp AS $$ SELECT ROW('None', 1000.0, 25, '(2,2)')::

JSON/JSONB documentation, aggregate functions

2022-09-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-json.html Description: Regarding the Json documentation (9.16.1: processing and creating JSON data), I would like to suggest that the reference to json_agg/jsonb_agg/json_object_

pg_dump: regular expression notation for tables

2022-09-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/app-pgdump.html Description: Hi, The pg_dump page mentions: https://www.postgresql.org/docs/current/app-pgdump.html#PG-DUMP-EXAMPLES == To dump all schemas whose names start with east or

TABLESPACE

2022-09-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createtablespace.html Description: When exporting a table create script pgAdmin includes a command "TABLESPACE pg_default;" such as below CREATE TABLE IF NOT EXISTS "DbTest"."Test" (

No discussion of custom variables; no "See also" for set_config, current_setting, pg_settings

2022-09-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-set.html Description: A reader of this section https://www.postgresql.org/docs/current/sql-set.html of the documentation might be forgiven for thinking that Postgres does not support c

[`] Paragraph doesn't match example in

2022-08-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/role-membership.html Description: In § 22.3 there's a paragraph stating > Immediately after connecting as role joe, a database session will have use of privileges granted directly to joe

INSERT RETURNING

2022-08-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/dml-returning.html Description: If I execute the below query ``` CREATE TABLE users ( id serial primary key, name varchar(255) ) INSERT INTO users (name) VALUES ('a'), ('b'), ('c') RET

Section 40.1 Overview of Event Trigger Behavior, and Table 40.1 missing needed details

2022-08-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/event-trigger-matrix.html Description: RE: https://www.postgresql.org/docs/current/event-trigger-matrix.html Section 40.1. Overview of Event Trigger Behavior says: "The table_rewrite even

Handling of quantity in recursive query example

2022-08-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/queries-with.html Description: I believe that the second query in section 7.8.2 (Recursive Queries) should be modified to properly account for quantities. In the recursive term, p.quantity

No backup history file found

2022-08-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/continuous-archiving.html Description: Chapter 26.3.2. "Making a Base Backup" states that "To make use of the backup, you will need to keep all the WAL segment files generated during and a

Typo in docs for "recovery_init_sync_method" parameter.

2022-08-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/runtime-config-error-handling.html Description: The second paragraph contains the sentence: > ...to ask the operating system to synchronize the whole file systems that contain the dat

Should 'sum(mvf)' read 'sum(mcv)'...?

2022-08-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/row-estimation-examples.html Description: About halfway down this page https://www.postgresql.org/docs/current/row-estimation-examples.html we see the following formula for calculating sel

Typo in description of PROGRAM parameter for the COPY command

2022-08-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-copy.html Description: On this page https://www.postgresql.org/docs/current/sql-copy.html the description of the PROGRAM parameter for the COPY command has the following sentence with

documentation error

2022-08-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions.html Description: Dear all, I am using documentation says " The psql commands \df and \do can be used to list all available functions and operators, respectively." which cle

relpages in pg_class

2022-08-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/catalog-pg-class.html Description: From source code, the relpage is the number of blocks. But, at the document, it is written as Size of the on-disk representation of this table in pages (

Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/pgtrgm.html Description: Hey guys, I have a question regarding the trigram algorithm and I can not find any information about it in your documentation: Do you distinguish between lower a

52.88. pg_shmem_allocations, missing units

2022-08-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/view-pg-shmem-allocations.html Description: Could someone add the units of size & allocated_size on the documentation for pg_shmem_allocations? Currently there aren't any listed. https:/

"22.3. Template Databases" documentation is incomplete

2022-08-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/manage-ag-templatedbs.html Description: The documentation for creating databases from templates is incomplete, and should mention that access privileges are not copied. So, for example, i

Unclear text at https://www.postgresql.org/docs/14/when-can-parallel-query-be-used.html

2022-08-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/when-can-parallel-query-be-used.html Description: "In addition, the system must not be running in single-user mode. Since the entire database system is running in single process in this si

34.16. The Password File error re windows pgpass.conf location

2022-08-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/libpq-pgpass.html Description: On this page: https://www.postgresql.org/docs/current/libpq-pgpass.html It incorrectly states: %APPDATA%\postgresql\pgpass.conf In reality this files nee

The sample FDW table: pglog not work in https://www.postgresql.org/docs/14/file-fdw.html

2022-08-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/appendixes.html Description: Dear All, CREATE FOREIGN TABLE pglog ( log_time timestamp(3) with time zone, user_name text, database_name text, process_id integer, connection_from

Usage instructions for pg_hba.conf file

2022-08-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/auth-pg-hba-conf.html Description: On the pg_hba.conf page, https://www.postgresql.org/docs/current/auth-pg-hba-conf.html, the bulk of the page involves the format of the file and what the

Typo in "43.9.1. Reporting Errors and Messages"?

2022-08-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/plpgsql-errors-and-messages.html Description: Towards the end of the "43.9.1. Reporting Errors and Messages" section (here https://www.postgresql.org/docs/current/plpgsql-errors-and-messag

Dependency Tracking to be updated with PostgreSQL 14 functions on dependencies improvement.

2022-07-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/ddl-depend.html Description: In PostgreSQL 14, we have added feature to check dependencies for function defined with sql_body or language as SQL. Reference :- https://www.postgresql.org/do

Bug in code sample in "8.15.5. Searching in Arrays"

2022-07-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/arrays.html Description: The section on array searching here: https://www.postgresql.org/docs/current/arrays.html#ARRAYS-SEARCHING ...says "In addition, you can find rows where the

Correction

2022-07-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/citext.html Description: "If you declare a column as UNIQUE or PRIMARY KEY, the implicitly generated index is case-sensitive. So it's useless for case-insensitive searches, and it won't en

pg_advisory_unlock(null)

2022-07-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-admin.html Description: Hello! There is no information in documentation about pg_advisory_unlock with NULL value. This call: select pg_advisory_unlock(null), returns null without

"Getting Started" guide is missing a critical step?

2022-07-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-createdb.html Description: Hello, I'm new to postgres so following through the steps in "Chapter 1. Getting Started". I was surprised to see that the chapter goes directly from

64.4.2. Bottom-up Index Deletion

2022-07-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/btree-implementation.html Description: on this url 64.4.2. Bottom-up Index Deletion, https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION Would be nice to add a no

Docs for string_to_array missing for Postgres 14

2022-07-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-array.html Description: At the bottom of the docs on "Array Functions and Operators" for Postgres 14 (see https://www.postgresql.org/docs/14/functions-array.html) there is a NOTE

Typo in examples in "8.14.5. jsonb Subscripting"

2022-07-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-json.html Description: Towards the end of the section, the code examples given have comments where the JSON is using single quotes instead of double quotes around the properties.

Query planner documentation should mention xxx_collapse_limit parameters

2022-06-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/git.html Description: We've spent days investigating a performance issue related to "explicit join order"/"from_collapse_limit", where we would have expected a query using "explicit join c

How to reference the type of lock in the documentation.

2022-06-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/explicit-locking.html Description: On page https://www.postgresql.org/docs/10/explicit-locking.html, I'd like to suggest a search-engine-optimization improvement. Generally, but especially

No search results for "BETWEEN"

2022-06-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-comparison.html Description: For some reason, searching for "BETWEEN" (no quotes) on the docs site returns no hits: https://www.postgresql.org/search/?q=BETWEEN This is surpris

Didn't correct output for LTRIM function

2022-06-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/bug-reporting.html Description: First check the output of "select LTRIM(' startech academy ', ' sta');" output is "rtech academy " now the thing is output of "select LTRIM(' starte

COPY FROM

2022-06-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-copy.html Description: When copying a csv file into a table, ifthere is a string missing a double quote in the end, COPY will return an error saying the string is infinitely long. But

Mention RETURNING ... INTO target

2022-06-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-insert.html Description: It looks like INSERT INTO ... RETURNING allows defining a target for the returned values like SELECT ... INTO does. This could be mentioned in the synopsis,

Unclear Wording

2022-06-07 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/plpgsql-errors-and-messages.html Description: Dear Sirs, From the page on RAISE ... I read this 3 times and tripped over "write a format", which should be use (or specify) a format str

Section I - 2.9: Use SELECT to confirm set of rows before DELETE

2022-06-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-delete.html Description: Since this tutorial section is coined at beginners, I think it could be useful to tip users about the possibility to use a SELECT statement with the exact

Proposal to improve uniq function documentation in intarray extension

2022-06-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/intarray.html Description: The **uniq** function in the **intarray** extension removes **adjacent** duplicates from an integer array. The documentation[0] about this behavior is correct, b

CREATE EXTENSION not adding extension on second SCHEMA

2022-05-31 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createextension.html Description: I'm trying to add an extension to two schemas that I have in my DB. steps: 1) CREATE EXTENSION unaccent with SCHEMA public; response: OK. 2) CR

INVALID index while concurrent indexing in progress?

2022-05-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createindex.html Description: I think the INVALID index can use further explanation, in particular, from my experience it seems like when building an index concurrently, the index gets

Spelling Mistake

2022-05-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-sql-intro.html Description: Hello, I was going through the docs, and on page: https://www.postgresql.org/docs/current/tutorial-sql-intro.html the first code block is as shown:

Reserved word: OWNER

2022-05-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-keywords-appendix.html Description: You say it's a non-reserved word, but on this page: https://www.postgresql.org/docs/current/sql-alterdatabase.html#:~:text=To%20alter%20the%20owner%

SET TRANSACTION SNAPSHOT sounds like replicated environment but isn't

2022-05-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-set-transaction.html Description: Hello, the wording on the SET TRANSACTION SNAPSHOT left me a bit confused. It says "To begin a new transaction with the same snapshot as an already e

correction

2022-05-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/transaction-iso.html Description: in this page: https://www.postgresql.org/docs/14/transaction-iso.html under the Table 13.1 section, if we search for "phantom reads. Stricter behavior is

Docs about INSERT wait in Read Commited transaction

2022-05-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/transaction-iso.html Description: Hello I've noticed, if two transactions in read committed mode are trying to insert same value to unique column, second transaction INSERT will wait for t

Specify bytes storage for enum data types

2022-05-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-enum.html Description: I love Postgres !! And also its documentation !! While reading through data types, it occurred to me that most ( if not every ) other data types has a char

BETWEEN operator not indexed

2022-05-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/functions-comparison.html Description: The BETWEEN operator can't be found by searching.

Clarification of triggers with 'OF column_name' in 'Overview of Trigger Behavior'

2022-05-02 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/trigger-datachanges.html Description: This caught me out because I was looking at the wrong page, so I figured it might be a good addition. I'm running version 'PostgreSQL 13.2 (Debian 13.

Documentation Suggestion

2022-04-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/app-initdb.html Description: Reference: https://www.postgresql.org/docs/11/app-initdb.html When installing recently I found the "-A " option of the initdb command only accepts lowercase

Mixed field in table 70.3

2022-04-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/storage-page-layout.html Description: The 7th line states: pd_pagesize_version uint16 2 bytes Page size and layout version number information In fact there are two smallints

What is a "simple expression"?

2022-04-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-select.html Description: Hi there To start off I'd like to say your documentation is great and very helpful. Thanks for that! https://www.postgresql.org/docs/14/sql-select.html in th

'CREATE OR REPLACE FUNCTION' behavior whenever a transaction is running

2022-04-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createfunction.html Description: The page does not mention what is the default behavior whenever a function is replaced while the same function is being used in another query/transacti

"GIN and GiST Index Types" page is about usage in full text search, but looks general purpose

2022-04-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/textsearch-indexes.html Description: Hey, when you google for "postgresql gist gin index" you will most probably see this page (or an older version of it) as #1 and the only result from p

role attributes are missing from this page

2022-04-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/role-attributes.html Description: Issue #1: "old" is a keyword, but I cannot query the old column explicitely with surrounding quotes. SELECT "old" FROM pg_roles; Issue #2: You do not hav

Missing example for SAVEPOINT using the same savepoint name

2022-04-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-savepoint.html Description: The "Compatibility" section deserves some code example to illustrate the behavior when reusing the same savepoint name. Maybe this could help: CREATE TABL

41.3. Materialized Views: Create table should be create view?

2022-04-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/rules-materializedviews.html Description: CREATE TABLE mymatview AS SELECT * FROM mytab; Should be the creation of view instead.

Add further details to ROW SHARE table level lock modes section

2022-04-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/explicit-locking.html Description: The ROW SHARE table level lock modes section currently states: ``` Conflicts with the EXCLUSIVE and ACCESS EXCLUSIVE lock modes. The SELECT FOR UPDATE a

The ltree example could lead to misunderstandings on usage of the ltree type

2022-04-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/ltree.html Description: For all documentation versions of https://www.postgresql.org/docs/14/ltree.html the example "Top.Countries.Europe.Russia" is not entirely correct: Russia is located

GENERATED ALWAYS AS - Not Consistent with MD5

2022-03-24 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/ddl-generated-columns.html Description: In my table definition - my Id Column is defined as ```Id TEXT PRIMARY KEY GENERATED ALWAYS AS (MD5(date_part('epoch', Inv_Date)::TEXT || TerminalId

SQL "RETURNING * | output_expression [ [ AS ]" is wrong

2022-03-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-update.html Description: https://www.postgresql.org/docs/14/sql-update.html Hi! AFAIK, UPDATE RETURNING works with INTO varname, not AS Documentation says: UPDATE [ WITH [ RECU

systemd service start - disable timeout with "infinity"

2022-03-20 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/server-start.html Description: In the service start section of the documentation, it is stated that using a value of zero for TimeoutSec disables the systemd timeout. This is not accurate

"Restore" vs. "Reload"

2022-03-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/backup-dump.html Description: Hello, As far as I can see, the terms "Reload" and "Restore" are used interchangeably. To make the page as easy digestable for the reader as possible, it´s ad

returning clause is not clearly documented

2022-03-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/dml-returning.html Description: Hello there I'm not good enough in english, so have my excuse. I don't undestand how Returning clause work when more than on row are affected. i.e I have a

Missing information about CREATE TRIGGER on temporary tables

2022-03-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createtrigger.html Description: To be confirmed by the developer community... The reference page about CREATE TRIGGER should indicate if it's allowed to create triggers on temp tables.

Missing tags ALTER ROUTINE and DROP ROUTINE in Event Trigger Firing Matrix

2022-03-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/event-trigger-matrix.html Description: Hi, "ALTER ROUTINE" and "DROP ROUTINE" are not listed in the "Event Trigger Firing Matrix" documentation page, even though these tags seem supported

Copy Documentation

2022-02-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-copy.html Description: The documentation states that headers are only used for CSV files, but there is a header "PGCOPY" when using a BINARY export. e.g. COPY (SELECT zipfile FROM file

Does the POSITION() function takes into account the COLLATION... or not ?!?

2022-02-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-string.html Description: The doc doesn't say anything about the impact of the COLLATION on the results of any of the string functions, so I tried some interesting tests with POSI

Doc says nothing about wether CREATE OR REPLACE VIEW can change the COLLATION of an existing field

2022-02-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createview.html Description: What the doc says about CREATE OR REPLACE VIEW : "The new query must generate the same columns that were generated by the existing view query (that is, th

tutorial problem solution requires that problem is already fixed

2022-02-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/role-attributes.html Description: I am reporting my roadblock, so it can be better documented in the future. I am following this tutorial: https://www.postgresql.org/docs/14/tutorial-crea

Data Type Size Calculation

2022-02-11 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-numeric.html Description: > The actual storage requirement is two bytes for each group of four decimal digits, plus three to eight bytes overhead. Please describe what 'overhead'

CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data

2022-02-09 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createtableas.html Description: If I create a table with CREATE TABLE IF NOT EXISTS table_name AS, and the table exists already, I get a NOTICE instead of an ERROR. I wanted to have i

Transactions in postgres

2022-02-05 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/tutorial-transactions.html Description: What is discussed in the transaction article is valid as long as the commit is made in the place where the stored procedure was invoked, since if th

Minor error in calling a python list a tuple

2022-02-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/plpython-data.html Description: Hello, In the link bellow there is the mentioned error. https://www.postgresql.org/docs/13/plpython-data.html#PLPYTHON-ARRAYS CREATE FUNCTION make_pair (na

documentation typo

2022-01-30 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/lo-interfaces.html Description: I assume "inv_oid = lo_creat(conn, INV_READ|INV_WRITE);" should be "inv_oid = lo_create(conn, INV_READ|INV_WRITE);", right? https://www.postgresql.org/docs/

Datetime formatting

2022-01-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-datetime.html Description: The latest ISO 8601-1:2019 standard requires the "T" character as the separator in text representations of datetimes. RFC 3339 is more flexible and all

Conventions

2022-01-25 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/notation.html Description: In section 3, Conventions, it would be helpful to point out that parentheses, when used in the command descriptions, are to be interpreted as literal required el

array_to_string and string_to_array

2022-01-22 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-array.html Description: Hi, I suggest it would be wise to extend the definition of array_to_string (Table 9.52) by linking to string_to_array (Table 9.10). It would also be wise

Not clear sentence

2022-01-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/backup-dump.html Description: URL: https://www.postgresql.org/docs/current/backup-dump.html Text: This is necessary to fully backup the cluster if running the pg_dump command on individu

idle_session_timeout doc

2022-01-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/runtime-config-client.html Description: Is there a way to alter users idle_session_timeout setting? My understanding is that it's a global setting. The last sentence indicates you can ap

gettext instructions for Windows seems wrong

2022-01-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/install-windows-full.html Description: I have to build Postgres on Windows 10. I got everything building from a git checkout without NLS. I followed the instructions the way I understood t

missing a white space in the last sentence of 51.6. Executor

2022-01-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/executor.html Description: The last sentence of 51.6. Executor appears: "...feeding that up toModifyTable to perform the insertion." The below might be correct: "...feeding that up to Mod

CREATE INDEX USING documentation

2022-01-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-createindex.html Description: In the CREATE INDEX synopsis(https://www.postgresql.org/docs/current/sql-createindex.html), the USING method parameter is listed, however in the PARAMETER

Why can NUMERIC columns not use deduplication?

2022-01-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/btree-implementation.html Description: "64.4.3. Deduplication" says: "numeric cannot use deduplication. Numeric display scale must be preserved among equal datums." However I don't under

.pg_service.conf default location and default name on MS Windows platform

2022-01-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/libpq-pgservice.html Description: Can you please add note about file ".pg_service.conf" default location and default name on MS Windows platform? Why? Accoring to my experience the default

pg_isready docs doesn't specify what exactly it is checking

2022-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/app-pg-isready.html Description: `pg_isready` docs don't specify how its different from a port probe - what does on top of checking that a port is open? Does it send some handshake message

role_table_grants only shows grantees that are "groups"?

2022-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/infoschema-role-table-grants.html Description: It seems like the "grantee" column in this table is only ever a "group", not just roles in general as the documentation seems to say. I know

Add TypeScript driver

2022-01-04 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/external-interfaces.html Description: Hi. I am Eray Hanoglu, author of postgresql-client javascript driver written in TypeScript (https://www.npmjs.com/package/postgresql-client). It is an

vectorization is not helping with plural to singular matching

2022-01-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/textsearch-intro.html Description: SELECT to_tsvector('fat cats ate fat rats') @@ to_tsquery('fat & rat'); This is giving false, even I tried for various other examples for plural to sin

Typo in "27.2.8. Synchronous Replication"

2021-12-26 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/warm-standby.html Description: The following sentence: > The minimum wait time is the round-trip time **between primary to standby.** Should either end with "...between primary AND stand

^@ operator for text

2021-12-23 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-string.html Description: In the new documentation https://www.postgresql.org/docs/14/functions-string.html you again lost information about ^@ operator for text and keep informa

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