1. Version Overview

[Release date: June 04, 2025]

IvorySQL 4.5, based on PostgreSQL 17.5 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

2. Enhancements & Fixed Issue

  • PostgreSQL 17.5 Enhancements

    1. Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding.

    2. Handle self-referential foreign keys on partitioned tables correctly.

    3. Avoid data loss when merging compressed BRIN summaries in brin_bloom_union().

    4. Correctly process references to outer CTE names that appear within a WITH clause attached to an INSERT/UPDATE/DELETE/MERGE command that’s inside WITH.

    5. Fix ALTER TABLE ADD COLUMN to correctly handle the case of a domain type that has a default.

    For further details, visit PostgreSQL’s release notes.

  • IvorySQL 4.5

    1. MIPS Packaging for All Platforms: Feature #736

      Provides multi-platform media packages for MIPS architecture, supporting both domestic and international mainstream operating systems, including Red Hat, Debian, Kylin, UOS, and NSAR OS, etc.

    2. IvorySQL Online trail: Feature #1

      Provide users with a web-based platform to experience IvorySQL V4.5 in an online environment, enabling database interaction directly through a browser interface.

    3. Add code of conduct: Feature #808

    4. Update the community contribution guide: Feature #121

    5. Automate Documentation Build and Website Update via Pull Requests: Feature #115

    6. Enhanced Contributor Workflow: Self-Assign Issues by using the '/assign' command: Feature #109

    7. IvorySQL Operator V4 has been adapted to support IvorySQL 4.5, with upgrades to system component versions and database extension versions : Feature #79

3. Source Code

IvorySQL’s development is maintained across two main repositories:

4. 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

  • Flyingbeecd

  • Ge Sui

  • Grant Zhou

  • Hulin Ji

  • Hope Gao

  • Lily Wang

  • Renli Zou

  • Shawn Yan

  • Shihua Yang

  • Shiji Niu

  • Shoubo Wang

  • Shuntian Jiao

  • Xiangyu Liang

  • Xinjie Lv

  • Zheng Tao

  • Zhenhao Pan

  • Zhuoyan Shi