information_schema.tables table broken in versions 13+

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/infoschema-tables.html Description: The table on information_schema.tables documentation page is broken after version 12. Instead of three columns in header and body all text is packed

max_sync_workers_per_subscription

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/logical-replication-config.html Description: max_sync_workers_per_subscription option is not added.

pmap grep zero fail to load vm_peak

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/kernel-resources.html Description: pmap 4170 | awk '/rw-s/ && /zero/ {print $2}' is not working if I Do pmap 4170 | awk '/rw-s/ && /zero/ {print $2}' I get 2ac0 1099776K

postgres_fdw installation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/postgres-fdw.html Description: 1. Install the postgres_fdw extension using CREATE EXTENSION. Doesn't actually work or is a bit light on detail, some info on how to install the extension

Analyze on Foreign Data Wrappers - clarification

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/sql-analyze.html Description: Foreign tables are analyzed only when explicitly selected. Nothing wrong just maybe my newness to PG. I don't understand what "selected" means here: 1.

Remove unary operator documentation https://www.postgresql.org/docs/current/datatype-oid.html

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/datatype-oid.html Description: On page https://www.postgresql.org/docs/current/datatype-oid.html, for regoperator the example "-(NONE,​integer)" is mentioned. Do I understand correctly

9.17. Sequence Manipulation Functions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/functions-sequence.html Description: Just a slip of the pen in the table "Function Description", in tha string: "setval ( regclass, bigint [, boolean ] ) → bigint", i think that something

Correction to documentation at https://www.postgresql.org/docs/12/kernel-resources.html

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/kernel-resources.html Description: Hi. On https://www.postgresql.org/docs/12/kernel-resources.html, the command to calculate memory allocated to postgres is not correct. Following is the

clarification on chaining of set operations

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/queries-union.html Description: Apologies if this has been raised previously - I searched the archives and did not find anything. Regarding section 7.4 of the documentation. I was

Number of GiST support functions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/gist-extensibility.html Description: The documentation states that > There are five methods that an index operator class for GiST must provide, and five that are optional. although

GiST indexes appear no longer rely on the first column

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/indexes-multicolumn.html Description: This statement under the GiST index: "the condition on the first column is the most important one for determining how much of the index needs to be

Rolinherit- Role automatically inherits privileges of roles it is a member of

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/9.6/view-pg-roles.html Description: Roles do not inherit the rolconfig, please see the below labs, postgres=> grant test_audit_app_role to test_app ; GRANT ROLE postgres=> postgres=>

The huge_pages parameter doesn't work when shared_memory_type is sysv

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/kernel-resources.html Description: It seems that the huge_pages parameter is ignored when shared_memory_type is sysv. The server successfully starts with huge_pages=on, but actually

Default include_dir behaviour

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/config-setting.html Description: Dear postgres-team, please consider adding a short line which clarifies what the default behaviour of the `include_dir` paramter is if it is not set. I

Typos in 34.3.9. Truncating a Large Object

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/lo-interfaces.html Description: The first parameter for both lo_truncate and lo_truncate64 is missing an "N", it says "PGcon *conn", but should be "PGconn *conn".

vacuum_freeze_min_age description validity

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/routine-vacuuming.html Description: Hi All, I have a doubt about the vacuum_freeze_min_age explanation here; https://www.postgresql.org/docs/10/routine-vacuuming.html

13 25.1.1 clarify "The dumps produced by pg_dump are relative to template0"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/backup-dump.html Description: In doc version 13 section 25.1.1 it reads, "The dumps produced by pg_dump are relative to template0. This means that any languages, procedures, etc. added

Warn against transaction level advisory locks for emulating "flat file" DBMS locking strategies

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/explicit-locking.html Description: The docs mention "For example, a common use of advisory locks is to emulate pessimistic locking strategies typical of so-called “flat file” data

create rule

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/rules-views.html Description: Nowhere in the documentation is mentioned that rules can only be made on tables without dropped columns and, much to my suprise, on empty tables only. I

Keyword docs missing, or mislabelled keywords

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-keywords-appendix.html Description: https://www.postgresql.org/docs/13/sql-keywords-appendix.html Missing: BUFFERS (as found in EXPLAIN) COSTS (as found in EXPLAIN) MODULUS (as found

Simple re-wording

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/bug-reporting.html Description: "Before you report a bug, please read and re-read the documentation to verify that you can really do whatever it is you are trying." => "Before you report

Error in sql script

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/textsearch-configuration.html Description: In /13/textsearch-configuration.html, the last script block starts with some incorrect characters and we do not see the sql command to list the

I came here to determine how much storage a boolean variable uses

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype.html Description: I'd like to see a fourth column added to Table 8-1 that contains the size or size range of the data type. Maybe a note about the amount of space in the row that

refresh concurrently: limitation of diff refreshing

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-refreshmaterializedview.html Description: Hi, it may seem obvious, but it took us TB of WALs and some time to identify the problem, why a bigger materialized view created much more

Unclear\mistakable description of UPDATE behaviour in "13.2.1. Read Committed Isolation Level"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: hello! documentation for "read committed" says that: "UPDATE, DELETE, SELECT FOR UPDATE, and SELECT FOR SHARE commands ... ...If the first updater

Potential vuln in example for "F.25.1.1. digest()"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/pgcrypto.html Description: Hi, in "F.25.1.1. digest()" you suggest: CREATE OR REPLACE FUNCTION sha1(bytea) returns text AS $$ SELECT encode(digest($1, 'sha1'), 'hex') $$ LANGUAGE SQL

incorrect information in documentation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/row-estimation-examples.html Description: Hello, on page https://www.postgresql.org/docs/current/row-estimation-examples.html - there is a example: selectivity = (1 - null_frac1) * (1 -

vacuum_cost_page_miss (integer) -> read from disk or from outside of the shared buffers?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/runtime-config-resource.html Description: hi, i am not sure if definition of vacuum_cost_page_miss paraemter on https://www.postgresql.org/docs/current/runtime-config-resource.html is

create global table - invalidate previous comment

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-createtable.html Description: From the syntax on "create table" , I've understood that global/local may be used only for TEMP tables, so my previous report is incorrect. Sorry.

psql's commit df9f599b is not documented

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/app-psql.html Description: Hi quit and exit commands have been added to psql starting from psql 11 through this commit df9f599b

documentation describing the range of a number type 'integer' is incorrect

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-numeric.html Description: https://www.postgresql.org/docs/13/datatype-numeric.html says that the range of a numeric type integer is -2147483648 to +2147483647 but

Common case not at all clear

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: For all this documentation, it is completely unclear how to handle the most common, simple case. I.e. Select balance into :bal ...where key =123;

/usr/local/pgsql Location on Manjaro/Arch

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/backup-file.html Description: I'm running an up-to-date version of Manjaro Linux (510 kernel), and following this guide I wasn't able to find my database files in /usr/local/pgsql/data,

Headers for each index

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/indexes-types.html Description: For easier visual navigation could you please add headers or color the different types of indexes? At the moment, one needs to read the whole document or

Another pg_dump using split and gzip for large databases

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/backup-dump.html Description: pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz'

Exponentiation example not clear

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-math.html Description: Quoting the docs: Exponentiation (unlike typical mathematical practice, multiple uses of ^ will associate left to right) 2 ^ 3 → 8 2 ^ 3 ^ 3 → 512 You

user-defined function in Perl or Tcl ???

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-matching.html Description: https://www.postgresql.org/docs/current/functions-matching.html > If you have pattern matching needs that go beyond this, consider writing a

ddl-basics.html plural stuff

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-basics.html Description: Probably this is horribly pedantic but 'data' is a plural word and database people should of all humans know this. Datum is the singular. Should 'this many

getting table name from partition

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-partitioning.html Description: I would like to add a sentence like this into the description of partitions: You receive the name of the partition table data is from using

NOT DEFERRABLE constraints are checked before command finishes

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtable.html Description: According to the docs: A constraint that is not deferrable will be checked immediately after every command. But this is the behavior I observe on PG

Manua correction

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-string.html Description: Hopefully the referrer page was kept. I'm referring to the string functions page that reads... == position ( substring text IN string text ) → integer

markdown error

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-json.html Description: Tables for operators and functions in version 13 and devel 14 are broken https://www.postgresql.org/docs/current/functions-json.html

Second-granular timezone offset format not documented

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-formatting.html Description: I would like to request additional documentation on the timezone format that can be returned. Context: I had a problem with the HDBC-postgresql

ECPG cursor examples should include EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while loop

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ecpg-variables.html Description: Without this line: EXEC SQL WHENEVER NOT FOUND CONTINUE; after the while(1), I find that ECPG CURSOR examples fail. For example, this example under

docs issue in transactions section

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: 13.2.1. Read Committed Isolation Level Read Committed is the default isolation level in PostgreSQL. When a transaction uses this isolation level, a

SETOF specification and default behavior (CREATE FUNCTION)

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createfunction.html Description: It seems like an oversight that the synopsis for CREATE FUNCTION doesn't actually show the modifier "SETOF" as a optional literal part of the syntax

Document behaviour of failed sub queries

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-subquery.html Description: I have found that when a sub query fails, the preceeding IN will ignore the failure and execute as if the subquery did not exist. I think this should

Incorrect Syntax in Function Syntax diagram

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createfunction.html Description: | IMMUTABLE | STABLE | VOLATILE | [ NOT ] LEAKPROOF [ NOT ] LEAKPROOF is accepting separately , So why you written [ NOT ] LEAKPROOF with |

Change CLIENT_ENCODING to client_encoding plus a question on "SET NAMES"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/multibyte.html Description: Here is a tiny modification at [1] (change CLIENT_ENCODING to lowercase): -SET CLIENT_ENCODING TO 'value'; +SET client_encoding TO 'value'; Besides that,

Operator function clarification needed

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/gin-builtin-opclasses.html Description: https://www.postgresql.org/docs/12/gin-builtin-opclasses.html It is unclear what the operators do. Page should link to relevant section(s) of

24.1.5.1. Multixacts And Wraparound

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/routine-vacuuming.html Description: In section "24.1.5.1. Multixacts And Wraparound" of https://www.postgresql.org/docs/current/routine-vacuuming.html we find the following sentence

Misleading sentence about default privileges

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.html Description: In the docs (https://www.postgresql.org/docs/10/sql-alterdefaultprivileges.html) it states: > You can change default privileges only for

TIMEZONE names

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-datetime.html Description: The documentation states that some timezone names are recognized. As far as I understand others aren't. This seems to be true: $psql postgres -c "set

Clarification needed

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/libpq-pgpass.html Description: Web page https://www.postgresql.org/docs/13/libpq-pgpass.html Are the fields in the .pgpass file case sensitive by default? Obviously the password is, &

Cities name column name inconsistent

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-fk.html Description: In earlier sections of the tutorial, the cities table had a column called 'name'. In this chapter, when creating the revised schema with foreign keys, the

SQL Commands COPY

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-copy.html Description: The synopsis and parameters for the COPY command show the FORCE_QUOTE option with an underscore and requires column names to be enclosed with round brackets,

functions-matching.html: Tip says use "Per or Tcl ... ?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-matching.html Description: https://www.postgresql.org/docs/current/functions-matching.html ``` Tip If you have pattern matching needs that go beyond this, consider writing a

Typo in "13.2.3. Serializable Isolation Level"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: The following sentence: > Eliminate explicit locks, SELECT FOR UPDATE, and SELECT FOR SHARE where no longer needed due... Uses the word "where" when it

pg_prewarm

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/pgprewarm.html Description: To be added to the documentation: - Default location of autoprewarm.blocks - Configure the location of autoprewarm.blocks - How often does it dump the block

Vacuum full and reindex

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/docguide.html Description: The documentation for vacuum FULL since 9.0 should mentioned that reindexing is included in the process. For the moment, to get this information, we have to

Duplicate paragraph

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-syntax-lexical.html Description: Greetings I was going through the documentation of the SQL Language that you have provided and there is a possible duplicate paragraph that I noticed

No ENABLE_GSS in generated Visual Studio project files

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/install-windows.html Description: I tried to build using Visual Studio 2019. Although I have enable the kerberos support in the configuration file, the generated Visual Studio project

ALTER COLLATION ... REFRESH VERSION - sample script outdated

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-altercollation.html Description: The sample script that is given in section "Notes" finds only libc collations. If you omit joining "pg_depend" you also find outdated ICU collations.

pg_monitor role description

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/default-roles.html Description: "This role is a member of pg_read_all_settings, pg_read_all_stats and pg_stat_scan_tables." Is it correct sentence? It seems for me that pg_read_all_stats

pg_type_d.h location incorrect

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/libpq-exec.html Description: >The OIDs of the built-in data types are defined in the file include/server/catalog/pg_type_d.h in the install directory. The location of "pg_type_d.h" is

typo in doc for "Miscellaneous Coding Conventions"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/source-conventions.html Description: small fix in description at [1] as follows -If that were not done interrupted code that's currently inspecting errno might see the wrong value. +If

Error building for 64-bit Windows (10)

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/install-windows-full.html Description: The Solution.pm file has the following lines: if ($self->{options}->{gss}) {

Online Documentation Search Issue

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-comparison.html Description: Hi, Just an FYI, but I'm running into a somewhat annoying issue with the documentation search that I'm not sure you're aware of. Namely, searching

location of pgpass.conf

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/libpq-pgpass.html Description: The file location needs to be more clear. It didn't work on my Local profile, only my Roaming profile: AppData\Roaming\postgresql Although it should work

Foreign Keys being able to reference same table not spelled out in documentation

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-constraints.html Description: Hello, In Section 5.4.5 of the documentation regarding Foreign Key Constraints it is stated "A foreign key constraint specifies that the values [...]

pl/pgsql errors when multi-dimensional arrays are used

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/arrays.html Description: I have PostgreSQL 13. Let's declare the type below, then use it in pl/pgsql: create type typ1 as ( fld1 int[][] ); do $$ declare a

Wrong type for the left argument of the operator "|/" and "||/" in chapter 9.3

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-math.html Description: The left argument of the operator square root |/ and cube root ||/ in the current documentation is double precision. But to my experience that should also

Clarify how triggers relate to transactions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createtrigger.html Description: https://www.postgresql.org/docs/current/sql-createtrigger.html mentions the word "transaction" only once, in reference specifically to constraint

"68.4. Visibility Map" change suggestion.

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/storage-vm.html Description: Currently the documentation lists the line below; `Each heap relation has a Visibility Map (VM) to keep track of which pages contain only tuples that are

Alter sequence restart parameter type

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/sql-altersequence.html Description: Hi! I have some question about alter sequence. I can see in your documentation https://www.postgresql.org/docs/12/sql-altersequence.html Synopsis:

Chapter 30. Logical Replication slightly unclear

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/logical-replication.html Description: I think the below snippet from https://www.postgresql.org/docs/12/logical-replication.html reads pretty clear for a native English speaker, but I

regarding stored procedure

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/sql-createprocedure.html Description: This documentation is missing the part on the topic whether we can insert data in temporary table from Stored procedure output.

Rounding strategy

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-math.html Description: The 'round' mathematical function documentation doesn't specify its rounding strategy. If this would be documented then users can rely on its rounding

Typo in DATATYPE-JSONPATH

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-json.html Description: Hello, On the DATATYPE-JSONPATH page: https://www.postgresql.org/docs/13/datatype-json.html#DATATYPE-JSONPATH There is a line that shows that GIN indexes

Date/Time Functions and Operators

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-datetime.html Description: Please also include some examples that extract few columns from some tables. For e.g. SELECT EXTRACT(YEAR FROM hire_date) FROM Employee WHERE id =

Incorrect in Window Functions

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/tutorial-window.html Description: Link: https://www.postgresql.org/docs/12/tutorial-window.html > The first three output columns come directly from the table empsalary, and there is one

Typo in psql doc

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/app-psql.html Description: There is a spurious space inside the documentation: \set HISTFILE ~/.psql_history- :DBNAME instead of \set HISTFILE ~/.psql_history-:DBNAME

SELECT last_value FROM sequence_name;

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-sequence.html Description: Please add Note, how to get the (global) last value: SELECT last_value FROM sequence_name;

repeated info in sections 4.1.1, 4.1.2.3

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-syntax-lexical.html Description: Simply want to tell you that there is repeated almost word-in-word info in 4.1.1 (starting with "A variant of quoted identifiers allows including",

PL/Tcl - examples not working

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/pltcl-trigger.html Description: Example on this page is not working https://www.postgresql.org/docs/13/pltcl-trigger.html Gives ERROR: bind message supplies 1 parameters, but prepared

mingw.org fails to load anything of value

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/installation-platform-notes.html Description: 16.7.4. MinGW/Native Windows refers to the site http://www.mingw.org which for me loads a blank page

How to access SQL commands

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/database-roles.html Description: If you have no experience using SQL, you don't know how to access Postgres SQL functions Crucially, I need to know about: sudo su - postgres I didn't at

Logical replication restart position (restart_lsn)

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/warm-standby.html Description: Hi, I was struggling to understand why my logical replication clients (using the wal2json plugin) are not advancing the restart_lsn as much as I expected.

ssl connection with certificate

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/11/index.html Description: Good morning. Following the instructions https://www.postgresql.org/docs/11/ssl-tcp.html I can't establish a local connection with certificate. In the pg_hba.conf

Wrong distance shown in miles for extension earthdistance

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/earthdistance.html Description: Hi, I have installed CREATE EXTENSION CUBE; CREATE EXTENSION earthdistance; Post which I ran the following query: SELECT (POINT (19.974, 72.756)<@>

"there is no way to insert less than one row"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/dml-insert.html Description: The documentation here says the following: "Of course you can also insert more than one row, but there is no way to insert less than one row." I tried this in

A very confusing line...

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/role-membership.html Description: I guess the phrase because joe “inherits” admin's privileges should be changed to because joe was granted admin's privileges. The point is, otherwise

Duplicate "SELECT current_user;"

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/ddl-rowsecurity.html Description: On this page I see the following example: cut => SELECT current_user; current_user -- admin (1 row) => select inet_client_addr();

How are UUIDs sorted / compared ?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/datatype-uuid.html Description: I'm missing information about what really sets the UUID datatype apart? For example I'm missing information as to how the UUID is sorted, i.e. how two

Missing mention of autovacuum_work_mem

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/progress-reporting.html Description: The "vacuuming indexes" documentation has: "If a table has any indexes, this will happen at least once per vacuum, after the heap has been completely

advanced.sql tutorial script

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-advanced-intro.html Description: I built tutorial files according to instructions from the section 2.1. And I found that the script advanced.sql covers only the section "3.6.

INNER JOIN syntax is not commonly used?

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-join.html Description: This page shows a WHERE syntax to join tables. After that it shows an example of the INNER JOIN syntax: SELECT * FROM weather INNER JOIN cities ON

make tutorial 13.2

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/tutorial-sql-intro.html Description: https://www.postgresql.org/docs/13/tutorial-sql-intro.html This page tells how to make tutorial files: $ cd .../src/tutorial $ make I have a binary

Jumbled words

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/sql-createrole.html Description: "modified by later ALTER ROLE" to be changed to "modified later by ALTER ROLE".

Step 8 does not perform as documented

The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/12/continuous-archiving.html Description: Under the steps of Recovering with continuous logging, Step 8 says: "Start the server. The server will go into recovery mode and proceed to read

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