Version Overview
[Release Date: Jan 13, 2025]
IvorySQL 4.2, based on PostgreSQL 17.2 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.
Enhancements
- PostgreSQL 17.1 Enhancements
- Ensure cached plans are marked as dependent on the calling role when RLS applies to a non-top-level table reference.
- Make libpq discard error messages received during SSL or GSS protocol negotiation.
- Fix unintended interactions between SET SESSION AUTHORIZATION and SET ROLE.
- Prevent trusted PL/Perl code from changing environment variables.
-
Fix updates of catalog state for foreign-key constraints when attaching or detaching table partitions. For further details, visit PostgreSQL’s release notes.
-
PostgreSQL 17.2 Enhancements
- Repair ABI break for extensions that work with struct ResultRelInfo.
- Restore functionality of ALTER {ROLE|DATABASE} SET role.
- Fix cases where a logical replication slot's restart_lsn could go backwards.
- Avoid deleting still-needed WAL files during pg_rewind.
- Fix race conditions associated with dropping shared statistics entries. For further details, visit PostgreSQL’s release notes.
Fixed Issues
- Fix issue for pg_upgrade: Issue [#721]
- Provide Rocky9 installation package: Issue [#724]
- EN grammatical fixes in ivorysql_docs: Issue #95
Source Code
IvorySQL's development is maintained across two main repositories: - IvorySQL database source code: https://github.com/IvorySQL/IvorySQL - IvorySQL official website: https://github.com/IvorySQL/Ivory-www
Contributors
The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.
- Cary Huang
- Denis Lussier
- Fawei Zhao
- Grant Zhou
- Hope Gao
- Lily Wang
- Shawn Yan
- Shiji Niu
- Shoubo Wang
- Shuntian Jiao
- Xiangyu Liang
- Xinjie Lv
- Zhibin Wang