v14.2.0

What's Changed

• Re-range clone sequences to new group id during promotion (Backport PR#8638) by Muhammad Usama (@codeforall) in #8653
• Clean up orphaned Citus local shard copies when cloning the coordinator (Backport PR#8651) by Muhammad Usama (@codeforall) in #8656
• backport #8621 and #8625 to release-14.0 by Onur Tirtir (@onurctirtir) in #8685
• Redesign procedure 2PC skip: static analysis via PLpgSQL plugin (Backport PR#8566 to 14.2) by Muhammad Usama (@codeforall) in #8694
• Fix bugs in UPDATE dist_table .. WHERE shard_key = X AND false (Backport PR8692) by Muhammad Usama (@codeforall) in #8700
• [release-14.0] Use GetLatestSnapshot in CleanupRecordExists (#8594) by ibrahim halatci (@ihalatci) in #8714
• [release-14.0] Fix type mismatch when COLLATE is used with type cast (#8498) by ibrahim halatci (@ihalatci) in #8715
• [release-14.0] Fix segfault in EXPLAIN with LEFT JOIN and correlated subqueries (#8556) by ibrahim halatci (@ihalatci) in #8716
• [release-14.0] Fix CREATE EXTENSION IF NOT EXISTS for non-owner users (#8465) by ibrahim halatci (@ihalatci) in #8718
• [release-14.0] Fix crash on writable standby coordinator writing to a coordinator-local shard (#8561) by ibrahim halatci (@ihalatci) in #8717
• Add changelog for Citus v14.2.0 by ibrahim halatci (@ihalatci) in #8720

Full Changelog: v14.1.0...v14.2.0