1. Version Overview

[Release date: April 11, 2024]

IvorySQL 3.2, based on PostgreSQL 16.2, introduces Oracle XML function compatibility features along with a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

2. Enhancements

  • Oracle XML Function Compatibility

    This Feature integrates compatibility for various Oracle XML functions, including APPENDCHILDXML, DELETEXML, EXISTSNODE, EXTRACT(XML), EXTRACTVALUE, INSERTCHILDXMLAFTER, INSERTCHILDXMLBEFORE, INSERTCHILDXML, INSERTXMLAFTER, INSERTXMLBEFORE and UPDATEXML. For further details, visit issue #587.

  • PostgreSQL 16.2 Enhancements

    1. Ensure durability of CREATE DATABASE

    2. Ensure that column default values are correctly transmitted by the pgoutput logical replication plugin

    3. Re-validate a subscription’s connection string before use

    4. Return the correct status code when a new client disconnects without responding to the server’s password challenge

    5. In PL/pgSQL, support SQL commands that are CREATE FUNCTION/CREATE PROCEDURE with SQL-standard bodies

    For further details, visit PostgreSQL’s release notes.

3. Fixed Issue

  • Resolved documentation build failure: Issue #645

  • Eliminated build warnings: Issue #649

  • Corrected parameter issue with the to_date function: Issue #592

  • Fix label issues in create function: Issue #624

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.

  • Bei Fu

  • Cary Huang

  • David Zhang

  • Grant Zhou

  • Jiao Ren

  • Lei Shang

  • Leo X.M. Zeng

  • Lily Wang

  • Nan Jia

  • Shawn Yan

  • Shiji Niu

  • Shoubo Wang

  • Shuntian Jiao

  • Xiangyu Liang

  • Xinjie Lv

  • Xinyuan Guo

  • Xiuhua Ruan

  • Xueyu Gao

  • Ying Huang

  • Yonghao Li

  • Zheng Liu