1. Version Overview

[Release date: September 26, 2024]

IvorySQL 3.4, based on PostgreSQL 16.4, and Fixed a series of bugs. For a comprehensive list of updates, please visit our documentation site.

2. Enhancements

  • PostgreSQL 16.4 Enhancements

    1. Prevent unauthorized code execution during pg_dump

    2. Avoid incorrect results from Merge Right Anti Join plans

    3. Prevent infinite loop in VACUUM

    4. Fix failure after attaching a table as a partition, if the table had previously had inheritance children

    5. Fix input of ISO-8601 “extended” time format for types time and timetz

    For further details, visit PostgreSQL’s release notes.

3. Fixed Issue

  • Add support for oracle sequence: Issue #588

  • Support xmlisvalid function: Issue #695

  • Set limit 2000 for character type in oracle mode: Issue #561

  • Support for adding constraints to existing tables using the SQL command ALTER TABLE ADD (CONSTRAINT …​): Issue #612

  • Support TO_MULTI_BYTE(), TO_SINGLE_BYTE(), ASCIISTR(), COMPOSE(), DECOMPOSE() functions: Issue #609

  • Support X86 and ARM architecture for debian in docker_library project: #16

4. Source Code

IvorySQL’s development is maintained across two main repositories:

5. Contributors

The following individuals (in alphabetical order) have contributed to this release as patch authors, committers, reviewers, testers, or reporters of issues.

  • Cary Huang

  • Chase Wu

  • Chong Peng

  • Grant Zhou

  • Hope Gao

  • Håkan Arpfors

  • Imran Zaheer

  • Jiajie Zhou

  • Jiao Ren

  • Lei Feng

  • Lei Shang

  • Leo X.M. Zeng

  • Lily Wang

  • ShanInfo

  • Shawn Yan

  • Shiji Niu

  • Shoubo Wang

  • Shuntian Jiao

  • Xiangyu Liang

  • Xinjie Lv

  • Xinyuan Guo

  • Yi Wen