1. Version Overview

[Release Date: Mar 12, 2026]

IvorySQL 5.3 is built on PostgreSQL 18.3 and includes a variety of bug fixes. For a comprehensive list of updates, please visit our documentation site.

2. Enhancements

  • PostgreSQL 18.3

    1. Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version.

    2. Avoid incorrect complaint of invalid encoding when substring() is applied to "toasted" data.

    3. Fix oversight in the fix for CVE-2026-2007.

    4. Fix the volatility marking of json_strip_nulls() and jsonb_strip_nulls().

    5. Fix computation of the set of potentially-nulling outer joins for the output of a LATERAL UNION ALL subquery.

For further details, visit PostgreSQL’s release notes.

  • PostgreSQL 18.2

    1. Guard against unexpected dimensions of oidvector/int2vector.

    2. Harden selectivity estimators against being attached to operators that accept unexpected data types.

    3. Fix buffer overrun in contrib/pgcrypto’s PGP decryption functions.

    4. Fix inadequate validation of multibyte character lengths.

    5. Harden contrib/pg_trgm against changes in string lowercasing behavior.

For further details, visit PostgreSQL’s release notes.

3. New Features

  • Upgrade to PG 18.3 kernel: Feature #1199
    PostgreSQL kernel upgraded to version 18.3.

  • Upgrade to PG 18.2 kernel: Feature #1195
    PostgreSQL kernel upgraded to version 18.2.

  • Online Experience: IvorySQL 5.3: Feature #7
    An interactive, browser-based environment will be launched to allow users to explore and evaluate IvorySQL 5.3 in real time — no installation required.

  • Packaging for All Platforms:
    Provides multi-platform media packages for X86, ARM, MIPS, LoongArch architecture.

  • Containerized Deployment Support
    Supports one-click deployment of standalone or highly available IvorySQL 5.3 clusters via Docker Compose, Podman, Swarm, Helm, and the IvorySQL 5.3 Operator.

  • IvorySQL Cloud 5.3 released (Visual Database Lifecycle Management Platform)
    Offers a fully managed, graphical control plane that handles IvorySQL 5.3 database subscriptions, orchestrates end-to-end lifecycle operations, and integrates surrounding ecosystem services.

  • PostgreSQL Extensions
    Support for 10 Additional PostgreSQL Extensions: pg_cron, pgAudit, PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, system_stats, plpgsql_check, pgvector.

4. Fixed Issues

  • Clear build warnings: PR #1190

  • Fix raw_expression_tree_walker for ColumnRefOrFuncCall: Issue #1182

  • Fix the issue where upgrading from PostgreSQL to IvorySQL fails: Issue #1130

  • Improved error message about plisql usage is ivorysql.compatible_mode = 'pg': PR #1178

  • Fix array out-of-bounds read in token_is_col_id() - liboracle_parser.c: Issue #1159

  • Fix psql tab-completion showing INVISIBLEINCREMENT: Issue #1135

  • Fix variable reset bug in nested function expressions: Issue #1124

  • Fix type coercion failure with mixed positional/named parameters in packages and subprocedures: Issue #1006

  • Fix segfault when package procedure initializes local variable from parameter: Issue #1005

  • Fix regression failures caused by the new year: PR #1146

5. Source Code

IvorySQL’s development is maintained across four main repositories:

6. Contributors

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

  • Cédric Villemain

  • Fawei Zhao

  • Ge Sui

  • Grant Zhou

  • Oreo Yang

  • Pierre Forstmann

  • Rophy Tsai

  • Shuntian Jiao

  • Steven Niu

  • Xiangyu Liang

  • Xiaohui Liu

  • Xinjie LYU

  • Xueyu Gao

  • Yasir Hussain Shah

  • Yuan Li

  • Zheng Tao

  • Zhenhao Pan

  • Zhe Zhang

  • Zhuoyan Shi