pgsql: doc: PG 14 release notes, reorder items by significance

2021-05-13 Thread Bruce Momjian
doc: PG 14 release notes, reorder items by significance Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/521d08a21a2b1ba7038ccc815b8bccc3c9be1351 Modified Files -- doc/src/sgml/release-14.sgml | 1775 +- 1 file chang

pgsql: Convert misleading while loop into an if condition

2021-05-13 Thread David Rowley
Convert misleading while loop into an if condition This seems to be leftover from ea15e1867 and from when we used to evaluate SRFs at each node. Since there is an unconditional "return" at the end of the loop body, only 1 loop is ever possible, so we can just change this into an if condition. Th

pgsql: Fix autovacuum log output heap truncation issue.

2021-05-13 Thread Peter Geoghegan
Fix autovacuum log output heap truncation issue. The percentage of blocks from the table value reported by autovacuum log output (following commit 5100010ee4d) should never exceed 100% because it describes the state of the table back when lazy_vacuum() was called. The value could nevertheless exce

pgsql: doc: PG 14 release notes, adjust updates/deletes on partitions

2021-05-13 Thread Bruce Momjian
doc: PG 14 release notes, adjust updates/deletes on partitions Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b2d0c7c96711843c6e47fce71335d43127f81647 Modified Files -- doc/src/sgml/release-14.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

Re: pgsql: doc: update PG 14 release notes based on feedback

2021-05-13 Thread Alexander Korotkov
On Wed, May 12, 2021 at 12:40 AM Bruce Momjian wrote: > doc: update PG 14 release notes based on feedback FTS items now look good to me. Thanks! -- Regards, Alexander Korotkov

pgsql: Improve documentation example for jsonpath like_regex operator

2021-05-13 Thread Alexander Korotkov
Improve documentation example for jsonpath like_regex operator Make sample like_regex match string values of the root object instead of the whole document. The corrected example seems to represent a more relevant use case. Backpatch to 12, when jsonpath was introduced. Discussion: https://postg

pgsql: Improve documentation example for jsonpath like_regex operator

2021-05-13 Thread Alexander Korotkov
Improve documentation example for jsonpath like_regex operator Make sample like_regex match string values of the root object instead of the whole document. The corrected example seems to represent a more relevant use case. Backpatch to 12, when jsonpath was introduced. Discussion: https://postg

pgsql: Improve documentation example for jsonpath like_regex operator

2021-05-13 Thread Alexander Korotkov
Improve documentation example for jsonpath like_regex operator Make sample like_regex match string values of the root object instead of the whole document. The corrected example seems to represent a more relevant use case. Backpatch to 12, when jsonpath was introduced. Discussion: https://postg

pgsql: Last-minute updates for release notes.

2021-05-13 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2021-32027, CVE-2021-32028, CVE-2021-32029 Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/25387cc56d344eaa9545b8233496296cf6087477 Modified Files -- doc/src/sgml/release-10.sgml | 63 +

pgsql: Last-minute updates for release notes.

2021-05-13 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2021-32027, CVE-2021-32028, CVE-2021-32029 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a9c718bd2d35586da8ebdefa0b72fe7e0d1a725b Modified Files -- doc/src/sgml/release-12.sgml | 64 +

pgsql: Last-minute updates for release notes.

2021-05-13 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2021-32027, CVE-2021-32028, CVE-2021-32029 Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/cc6c63f8a26d9706bc4b256ac075401bb3d5f759 Modified Files -- doc/src/sgml/release-9.6.sgml | 63

pgsql: Last-minute updates for release notes.

2021-05-13 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2021-32027, CVE-2021-32028, CVE-2021-32029 Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/6c1cfccf226645f4c01b4fee8df2c4e3392f2a32 Modified Files -- doc/src/sgml/release-11.sgml | 64 +

pgsql: Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tli

2021-05-13 Thread Tom Lane
Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tlists. It's unusual to have any resjunk columns in an ON CONFLICT ... UPDATE list, but it can happen when MULTIEXPR_SUBLINK SubPlans are present. If it happens, the ON CONFLICT UPDATE code path would end up storing tuples that include t

pgsql: Last-minute updates for release notes.

2021-05-13 Thread Tom Lane
Last-minute updates for release notes. Security: CVE-2021-32027, CVE-2021-32028, CVE-2021-32029 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/9b93a33f455579ee8953c32721c03ff9163b7f96 Modified Files -- doc/src/sgml/release-13.sgml | 67 +

pgsql: Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tli

2021-05-13 Thread Tom Lane
Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tlists. It's unusual to have any resjunk columns in an ON CONFLICT ... UPDATE list, but it can happen when MULTIEXPR_SUBLINK SubPlans are present. If it happens, the ON CONFLICT UPDATE code path would end up storing tuples that include t

pgsql: Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tli

2021-05-13 Thread Tom Lane
Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tlists. It's unusual to have any resjunk columns in an ON CONFLICT ... UPDATE list, but it can happen when MULTIEXPR_SUBLINK SubPlans are present. If it happens, the ON CONFLICT UPDATE code path would end up storing tuples that include t

pgsql: Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tli

2021-05-13 Thread Tom Lane
Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tlists. It's unusual to have any resjunk columns in an ON CONFLICT ... UPDATE list, but it can happen when MULTIEXPR_SUBLINK SubPlans are present. If it happens, the ON CONFLICT UPDATE code path would end up storing tuples that include t

pgsql: Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tli

2021-05-13 Thread Tom Lane
Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tlists. It's unusual to have any resjunk columns in an ON CONFLICT ... UPDATE list, but it can happen when MULTIEXPR_SUBLINK SubPlans are present. If it happens, the ON CONFLICT UPDATE code path would end up storing tuples that include t

pgsql: Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tli

2021-05-13 Thread Tom Lane
Fix mishandling of resjunk columns in ON CONFLICT ... UPDATE tlists. It's unusual to have any resjunk columns in an ON CONFLICT ... UPDATE list, but it can happen when MULTIEXPR_SUBLINK SubPlans are present. If it happens, the ON CONFLICT UPDATE code path would end up storing tuples that include t

pgsql: Prevent integer overflows in array subscripting calculations.

2021-05-13 Thread Tom Lane
Prevent integer overflows in array subscripting calculations. While we were (mostly) careful about ensuring that the dimensions of arrays aren't large enough to cause integer overflow, the lower bound values were generally not checked. This allows situations where lower_bound + dimension overflow

pgsql: Prevent integer overflows in array subscripting calculations.

2021-05-13 Thread Tom Lane
Prevent integer overflows in array subscripting calculations. While we were (mostly) careful about ensuring that the dimensions of arrays aren't large enough to cause integer overflow, the lower bound values were generally not checked. This allows situations where lower_bound + dimension overflow

pgsql: Prevent integer overflows in array subscripting calculations.

2021-05-13 Thread Tom Lane
Prevent integer overflows in array subscripting calculations. While we were (mostly) careful about ensuring that the dimensions of arrays aren't large enough to cause integer overflow, the lower bound values were generally not checked. This allows situations where lower_bound + dimension overflow

pgsql: Prevent integer overflows in array subscripting calculations.

2021-05-13 Thread Tom Lane
Prevent integer overflows in array subscripting calculations. While we were (mostly) careful about ensuring that the dimensions of arrays aren't large enough to cause integer overflow, the lower bound values were generally not checked. This allows situations where lower_bound + dimension overflow

pgsql: Prevent integer overflows in array subscripting calculations.

2021-05-13 Thread Tom Lane
Prevent integer overflows in array subscripting calculations. While we were (mostly) careful about ensuring that the dimensions of arrays aren't large enough to cause integer overflow, the lower bound values were generally not checked. This allows situations where lower_bound + dimension overflow

pgsql: Prevent integer overflows in array subscripting calculations.

2021-05-13 Thread Tom Lane
Prevent integer overflows in array subscripting calculations. While we were (mostly) careful about ensuring that the dimensions of arrays aren't large enough to cause integer overflow, the lower bound values were generally not checked. This allows situations where lower_bound + dimension overflow

pgsql: Prevent asynchronous execution of direct foreign-table modificat

2021-05-13 Thread Etsuro Fujita
Prevent asynchronous execution of direct foreign-table modifications. Commits 27e1f1456 and 86dc90056, which were independently discussed, cause a crash when executing an inherited foreign UPDATE/DELETE query with asynchronous execution enabled, where children of an Append node that is the direct/