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

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

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

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.

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

"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

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

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

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

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

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

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.

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

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

"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

'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

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

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

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

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.

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.

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

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

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

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

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%

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:

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

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

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

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

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

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,

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

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

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

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

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

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.

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

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

"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

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

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

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

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

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

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

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

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

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

"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

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:/

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

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 (

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

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

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 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

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

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

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

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

[`] 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

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

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" (

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

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_

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)')::

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

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

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,

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.

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

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

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

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"

Comparison Predicates - example - documentation seems contradictory?

2022-10-07 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: https://www.postgresql.org/docs/14/functions-comparison.html See the heading: "Table 9.2. Comparison Predicates" "2 BETWEEN 3 AND 1 → f" # ok this is false.

regression tests require some file(s) to be installed first.

2022-10-10 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/install-procedure.html Description: This might be a documentation issue, and it might be an actual issue, I'm not sure. I was following the installation instructions from the https://www.

Server start with systemd and configured with IP address

2022-10-12 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: The url of the document is https://www.postgresql.org/docs/current/server-start.html My suggestion is add to the documentation in the segment that shows the

Section 9.7.3.2. Bracket Expressions should be rewritten

2022-10-12 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-matching.html Description: I am a Postgres newbie, and I find this part of what is generally excellent documentation quite confusing. It contains the following disclaimer: Note

COALESCE could use some better examples

2022-10-13 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/functions-conditional.html Description: Regarding: https://www.postgresql.org/docs/current/functions-conditional.html I ran into a situation where COALESCE was used like this ``` SELECT

Generated column using function

2022-10-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/ddl-generated-columns.html Description: Please could you add an example of a function for generated column that takes the record as an argument and creates the column using 2 column values

manual entry pg_restore

2022-10-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/app-pgrestore.html Description: the manual entry for pg_restore can easily be misinterpreted for the -f option -f filename --file=filename Specify output file for generated s

pl Lua

2022-10-17 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/external-pl.html Description: Your page, https://www.postgresql.org/docs/15/external-pl.html Please include another, active Lua binding for PostgreSQL. It is https://github.com/arcapos

crosstab documentation should add a note about use in materialized views

2022-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tablefunc.html Description: When using a crosstab in a materialized view, if the SQL is not qualified with a schema, that restoring a database from a dump may fail. See the discussion in h

nextval parameter is not clear

2022-10-18 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-sequence.html Description: https://www.postgresql.org/docs/14/functions-sequence.html I don't see here any hints about how to use this function, and what the regclass means. How

[very minor] Documentation suggestion

2022-10-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/logicaldecoding-synchronous.html Description: Very minor suggestion. Earlier on this page, commands are referred to that can cause "a deadlock". Later on the page, it says "cause deadlock"

Restriction on comments

2022-10-21 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-comment.html Description: I've recently been converting some DML which was intended for BigQuery to use PostgreSQL 14. Using a python client (using sqlalchemy and the postgresql+psyco

First Person (I) Should be avoided

2022-10-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/oid2name.html Description: This feels a little nit-picky. In the Examples $ # I wonder what file 155173 is ... suggested change: $ # what Postgres object does file 155173 represent ...

First Person (I) in documentation

2022-10-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/nls-translator.html Description: At the end of the first paragraph: There is (unsurprisingly) a PO mode for Emacs, which I find quite useful. Suggestion: There is (unsurprisingly) a PO

Use of First Person (I) in Documentation

2022-10-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/pgcrypto.html Description: Same preamble from before. We usually avoid first person. Table F.18. Hash Algorithm Speeds Find comment: That way I can show the speed with different numbers

Cursor Names are "Session Global while Opened"? (should be mentioned in the docs)

2022-10-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/plpgsql-cursors.html Description: Okay, I am not 100% sure how to explain what the issue is. Simply put. If I call a cursor: cur_this in a procedure. Then while that cursor is OPEN, I

First Person being used (only occurs in 2 other places in all of documentation)

2022-10-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/cube.html Description: I believe the use of First Person (I) is to be avoided in the documentation. It is incredibly rare in all of the documentation. This is a NUANCE issue, but so are w

SET feature

2022-10-28 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-set.html Description: Hi, I remember in version 9 , to use variable you had to change in the postgresql. Today it is easier , just use SET SESSION myprefix.myvariable = 'whatever'

Partitioned tables are not processed by autovacuum.

2022-11-01 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/runtime-config-autovacuum.html Description: There is a statement in the Postgres Docs: "Partitioned tables are not processed by autovacuum." https://www.postgresql.org/docs/15/routine-vacu

Missing documentation

2022-11-03 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/libpq-connect.html Description: On this page: https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS There is a list of keywords that can be specified as part of t

Example code bug: destination->data

2022-11-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/xfunc-c.html Description: 38.10.2. Base Types in C-Language Functions In the last example of the section, this line appears: memcpy(destination->data, buffer, 40); For me, this gave the

Possibly Incorrect Data Return

2022-11-08 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/tutorial-agg.html Description: Hello: I am working through the tutorial and the Doc page says the row count is 5 but my results show 0 records. Of course, I may be doing something wrong, t

Mistake in Syntax definition of ALTER TABLE

2022-11-14 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/15/sql-altertable.html Description: I think there's a mistake under "and table_constraint is:" where the different constraints are listed. Here: https://www.postgresql.org/docs/current/sql-al

<    6   7   8   9   10   11   12   13   >