IvorySQL 4.5 Released

IvorySQL 4.5 was officially released on June 4, 2025!

This new version offers full support for PostgreSQL 17.5, introduces a host of new features, and addresses known issues.

Enhanced Features

Enhancements from PostgreSQL 17.5:

• Fixed the single-byte buffer overread issue when validating invalid strings declared with GB18030 encoding
• Properly handled self-referential foreign keys on partitioned tables
• Prevented data loss when merging compressed BRIN summaries via brin_bloom_union()
• Corrected the parsing of external CTE names referenced by INSERT/UPDATE/DELETE/MERGE commands nested in WITH clauses
• Rectified the processing logic of ALTER TABLE ADD COLUMN for domain types with default values

For more details, refer to the PostgreSQL Release Notes.

New Features

• Upgraded to the PostgreSQL 17.5 kernel
• Full-platform MIPS packaging support: In addition to the existing ARM and X86 architectures, multi-platform media packages for the MIPS architecture are now available, compatible with mainstream domestic and international operating systems (including Kylin, UOS, NSAR OS, etc.)
• IvorySQL Online Experience: A web-based instant experience environment is provided, enabling users to operate the IvorySQL 4.5 database directly via a browser
• New Code of Conduct added
• Community Contribution Guidelines updated
• Implemented automatic document building and official website updates via PR
• Enhanced contributor workflow: Supported self-service task assignment with the /assign command
• IvorySQL Operator V4 adapted for IvorySQL 4.5, with system components and database extension versions upgraded

For more information about the new IvorySQL Online Experience feature, read the article IvorySQL-WASM: A No-Install Journey of Database Exploration.

Resolved Known Issues

• Fixed the enumeration value error of check_compatible_mode and assign_compatible_mode
• Corrected the description of GUC framework test results in the documentation
• Rectified the description of Oracle compatibility parameters in the documentation
• Fixed the README path issue in the documentation
• Resolved the problem where search_path failed to update when the compatibility mode was changed
• Fixed compatibility issues between ModifyTableContext and UpdateContext
• Addressed the ineffectiveness of the initdb -C identifier_case_switch command

For full details, see the IvorySQL 4.5 Release Notes.

Source Code

IvorySQL mainly consists of two code repositories:

• IvorySQL Database Source Code: https://github.com/IvorySQL/IvorySQL
• IvorySQL Official Website: https://github.com/IvorySQL/Ivory-www

Acknowledgements to Contributors

The following individuals (listed in alphabetical order) contributed to this release as patch authors, committers, reviewers, testers, or issue reporters:

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.