Six reverts
Version 19: 71 commits on REL_19_STABLE. Version 20: 46 commits on master. Reverted out of 19: 74 commits, in 6 reverts. Six features tracked, 2 still shipping. Window closed at d8408e8d682.
Summary
71 commits landed on the 19 branch in nine days. The six reverts in the same window name 74 commits between them.
Six reverts, newest first.
- Online data checksum transitions. September 16, Daniel Gustafsson.
- UPDATE and DELETE FOR PORTION OF. September 15, Peter Eisentraut.
- pg_get_role_ddl, pg_get_tablespace_ddl, pg_get_database_ddl. September 13, Andrew Dunstan.
- Support more object types within CREATE SCHEMA. September 11, Tom Lane.
- Don’t re-order the subcommands of CREATE SCHEMA. September 11, Tom Lane.
- Identifier casefolding from the default locale. September 10, Jeff Davis.
Three of the six revert features Robert Haas flagged on August 25. One reverts a feature not on that list. Two revert CREATE SCHEMA changes on compatibility grounds.
Tracked features removed from 19
On September 10, Amit Langote removed batching from the fast path for foreign key checks. Commit 25649d6e791. The per-row path remains in 19.
On September 15, Peter Eisentraut reverted UPDATE and DELETE FOR PORTION OF. Commit a9d2f728240. Twenty-three commits.
On September 16, Daniel Gustafsson reverted online data checksum transitions. Commit c05d5ce1236. Thirty commits.
SQL/PGQ property graphs was reverted on September 7, one day before this window opened. Forty-seven commits.
The checksums revert states its reason:
The feature to enable, or disable, data checksums in an online cluster saw a number of postcommit fixes during the beta period. Suspicions were raised about the risk of more issues surfacing after GA. To avoid shipping code which may have bugs, this reverts in full, or in part, the following commits.
The FOR PORTION OF revert states no reason. It lists twenty-three commit subjects, notes that the release notes entries go with them, and links to the discussion thread. Fourteen of the twenty-three begin with Fix, Forbid, Reject, Require, Avoid, or Enforce.
pg_get_ddl functions reverted
On September 13, Andrew Dunstan reverted pg_get_role_ddl(), pg_get_tablespace_ddl() and pg_get_database_ddl(). Commit db169985c10. Thirteen commits, the whole DDL reconstruction feature, following a thread Noah Misch opened on August 27. It is not one of the six tracked features.
The two CREATE SCHEMA reverts are Tom Lane’s, both on September 11. The commit messages cite compatibility breakage outweighing the functionality gain. Jeff Davis reverted identifier casefolding on September 10, citing an unintended behaviour difference for the builtin provider with locale C and a single-byte encoding.
Online checksums on master
The checksums revert landed on REL_19_STABLE only. On master the feature is unchanged and still under active development, with five commits on September 14. The worker, the state machine and all twenty-four of its test files remain. The feature is still targeted at version 20.
REPACK
Fifteen of the seventy-one commits touch REPACK and REPACK CONCURRENTLY, the largest tracked area on the branch this window.
Five of them narrow what the command accepts: restricted to the heap access method, refused on user catalog tables, failed on invalid indexes, failed on !indisready indexes, and disallowed when the replica identity index has been dropped.