IvorySQL Files

Version Overview

[Release Date: Jun 4, 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.

Enhancements

• PostgreSQL 17.5 Enhancements
• Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding.
• Handle self-referential foreign keys on partitioned tables correctly.
• Avoid data loss when merging compressed BRIN summaries in brin_bloom_union().
• 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.
• 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.

New Features

• Upgrade to PG 17.5 kernel: Feature [#807]

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

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

• Add code of conduct: Feature #808

• Update the community contribution guide: Feature #121
• Automate Documentation Build and Website Update via Pull Requests: Feature #115
• Enhanced Contributor Workflow: Self-Assign Issues by using the '/assign' command: Feature #109
• IvorySQL Operator V4 has been adapted to support IvorySQL 4.5, with upgrades to system component versions and database extension versions : Feature #79

Fixed Issues

• Wrong enum value in check_compatible_mode and assign_compatible_mode: Issue [#763]
• Wrong test result in GUC Framework: Issue #111
• Update oracle compatibility parameters: Issue #74
• Update README path to a hyperlink: PR #156
• Force the search_path to be re-computed when compatible_mode is changed: Issue [#760]
• Rename ModifyTableContext and UpdateContext for better compatibility: PR [#794]
• Set identifier_case_switch to value in pg_control file so that configure file value can take effect : Issue [#797]

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
• Cédric Villemain
• 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

Complete Changelog