pgsql: Fix typo in hash README.

2022-05-31 Thread Amit Kapila
Fix typo in hash README. Author: Peter Smith Discussion: https://postgr.es/m/CAHut+Pu-V22PiJF2ym9_NVZe-+qnycfyEX24dZm=7urwhdh...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0a050ee000b6783ac4b78e9eadb47a4e72912672 Modified Files -- s

pgsql: shm_mq_sendv: Fix flushing bug when receiver not yet attached.

2022-05-31 Thread Robert Haas
shm_mq_sendv: Fix flushing bug when receiver not yet attached. With the old logic, when the reciever had not yet attached, we would never call shm_mq_inc_bytes_written(), even if force_flush = true was specified. That could result in a situation where data that the sender believes it has sent is n

pgsql: Doc: fix mention of pg_dump's minimum supported server version.

2022-05-31 Thread Tom Lane
Doc: fix mention of pg_dump's minimum supported server version. runtime.sgml contains a passing reference to the minimum server version that pg_dump[all] can dump from. That was 7.0 for many years, but when 64f3524e2 raised it to 8.0, we missed updating this bit. Then when 30e7c175b raised it to

pgsql: Doc: fix mention of psql's minimum supported server version.

2022-05-31 Thread Tom Lane
Doc: fix mention of psql's minimum supported server version. Commit cf0cab868 removed describe.c's support for pre-9.2 server versions, but neglected to update this documentation reference. Discussion: https://postgr.es/m/gv0p278mb041917eb3e2fe8704b5ae2c6d2...@gv0p278mb0419.chep278.prod.outlook.

pgsql: Doc: fix mention of pg_dump's minimum supported server version.

2022-05-31 Thread Tom Lane
Doc: fix mention of pg_dump's minimum supported server version. runtime.sgml contains a passing reference to the minimum server version that pg_dump[all] can dump from. That was 7.0 for many years, but when 64f3524e2 raised it to 8.0, we missed updating this bit. Then when 30e7c175b raised it to

pgsql: Doc: fix mention of pg_dump's minimum supported server version.

2022-05-31 Thread Tom Lane
Doc: fix mention of pg_dump's minimum supported server version. runtime.sgml contains a passing reference to the minimum server version that pg_dump[all] can dump from. That was 7.0 for many years, but when 64f3524e2 raised it to 8.0, we missed updating this bit. Then when 30e7c175b raised it to

pgsql: Doc: fix mention of pg_dump's minimum supported server version.

2022-05-31 Thread Tom Lane
Doc: fix mention of pg_dump's minimum supported server version. runtime.sgml contains a passing reference to the minimum server version that pg_dump[all] can dump from. That was 7.0 for many years, but when 64f3524e2 raised it to 8.0, we missed updating this bit. Then when 30e7c175b raised it to

pgsql: Doc: fix mention of pg_dump's minimum supported server version.

2022-05-31 Thread Tom Lane
Doc: fix mention of pg_dump's minimum supported server version. runtime.sgml contains a passing reference to the minimum server version that pg_dump[all] can dump from. That was 7.0 for many years, but when 64f3524e2 raised it to 8.0, we missed updating this bit. Then when 30e7c175b raised it to

pgsql: Doc: fix mention of pg_dump's minimum supported server version.

2022-05-31 Thread Tom Lane
Doc: fix mention of pg_dump's minimum supported server version. runtime.sgml contains a passing reference to the minimum server version that pg_dump[all] can dump from. That was 7.0 for many years, but when 64f3524e2 raised it to 8.0, we missed updating this bit. Then when 30e7c175b raised it to

pgsql: Ensure ParseTzFile() closes the input file after failing.

2022-05-31 Thread Tom Lane
Ensure ParseTzFile() closes the input file after failing. We hadn't noticed this because (a) few people feed invalid timezone abbreviation files to the server, and (b) in typical scenarios guc.c would throw ereport(ERROR) and then transaction abort handling would silently clean up the leaked file

pgsql: Ensure ParseTzFile() closes the input file after failing.

2022-05-31 Thread Tom Lane
Ensure ParseTzFile() closes the input file after failing. We hadn't noticed this because (a) few people feed invalid timezone abbreviation files to the server, and (b) in typical scenarios guc.c would throw ereport(ERROR) and then transaction abort handling would silently clean up the leaked file

pgsql: Ensure ParseTzFile() closes the input file after failing.

2022-05-31 Thread Tom Lane
Ensure ParseTzFile() closes the input file after failing. We hadn't noticed this because (a) few people feed invalid timezone abbreviation files to the server, and (b) in typical scenarios guc.c would throw ereport(ERROR) and then transaction abort handling would silently clean up the leaked file

pgsql: Ensure ParseTzFile() closes the input file after failing.

2022-05-31 Thread Tom Lane
Ensure ParseTzFile() closes the input file after failing. We hadn't noticed this because (a) few people feed invalid timezone abbreviation files to the server, and (b) in typical scenarios guc.c would throw ereport(ERROR) and then transaction abort handling would silently clean up the leaked file

pgsql: Ensure ParseTzFile() closes the input file after failing.

2022-05-31 Thread Tom Lane
Ensure ParseTzFile() closes the input file after failing. We hadn't noticed this because (a) few people feed invalid timezone abbreviation files to the server, and (b) in typical scenarios guc.c would throw ereport(ERROR) and then transaction abort handling would silently clean up the leaked file

pgsql: Ensure ParseTzFile() closes the input file after failing.

2022-05-31 Thread Tom Lane
Ensure ParseTzFile() closes the input file after failing. We hadn't noticed this because (a) few people feed invalid timezone abbreviation files to the server, and (b) in typical scenarios guc.c would throw ereport(ERROR) and then transaction abort handling would silently clean up the leaked file

pgsql: Revert changes to CONCURRENTLY that "sped up" Xmin advance

2022-05-31 Thread Alvaro Herrera
Revert changes to CONCURRENTLY that "sped up" Xmin advance This reverts commit d9d076222f5b "VACUUM: ignore indexing operations with CONCURRENTLY". These changes caused indexes created with the CONCURRENTLY option to miss heap tuples that were HOT-updated and HOT-pruned during the index creation.

pgsql: Revert changes to CONCURRENTLY that "sped up" Xmin advance

2022-05-31 Thread Alvaro Herrera
Revert changes to CONCURRENTLY that "sped up" Xmin advance This reverts commit d9d076222f5b "VACUUM: ignore indexing operations with CONCURRENTLY". These changes caused indexes created with the CONCURRENTLY option to miss heap tuples that were HOT-updated and HOT-pruned during the index creation.

pgsql: Recommend scram-sha-256 instead of md5 authentication in docs

2022-05-31 Thread Magnus Hagander
Recommend scram-sha-256 instead of md5 authentication in docs PostgreSQL 14 changed the default to be scram-sha-256, so we should stop recommending the user to use md5 or even worse password. Suggested-By: Daniel Westermann Author: Jonathan S. Katz Backpatch-through: 14 Discussion: https://postg

pgsql: Recommend scram-sha-256 instead of md5 authentication in docs

2022-05-31 Thread Magnus Hagander
Recommend scram-sha-256 instead of md5 authentication in docs PostgreSQL 14 changed the default to be scram-sha-256, so we should stop recommending the user to use md5 or even worse password. Suggested-By: Daniel Westermann Author: Jonathan S. Katz Backpatch-through: 14 Discussion: https://postg

pgsql: Doc: mention limitation of the number of resultset columns

2022-05-31 Thread David Rowley
Doc: mention limitation of the number of resultset columns The PostgreSQL limitations section of the documents mentioned the limit on the number of columns that can exist in a table. Users might be surprised to find that there's also a limit on the number of columns that can exist in a targetlist

pgsql: Doc: mention limitation of the number of resultset columns

2022-05-31 Thread David Rowley
Doc: mention limitation of the number of resultset columns The PostgreSQL limitations section of the documents mentioned the limit on the number of columns that can exist in a table. Users might be surprised to find that there's also a limit on the number of columns that can exist in a targetlist

pgsql: Doc: mention limitation of the number of resultset columns

2022-05-31 Thread David Rowley
Doc: mention limitation of the number of resultset columns The PostgreSQL limitations section of the documents mentioned the limit on the number of columns that can exist in a table. Users might be surprised to find that there's also a limit on the number of columns that can exist in a targetlist

pgsql: Doc: mention limitation of the number of resultset columns

2022-05-31 Thread David Rowley
Doc: mention limitation of the number of resultset columns The PostgreSQL limitations section of the documents mentioned the limit on the number of columns that can exist in a table. Users might be surprised to find that there's also a limit on the number of columns that can exist in a targetlist