1. Version Overview

[Release Date: Apr 21, 2026]

IvorySQL 1.22, based on PostgreSQL 14.22 and includes a variety of bug fixes.

2. Enhancements

  • PostgreSQL 14.18-14.22 Enhancements

    1. Avoid one-byte buffer overread when examining invalidly-encoded strings that are claimed to be in GB18030 encoding.

    2. Handle self-referential foreign keys on partitioned tables correctly.

    3. Tighten security checks in planner estimation functions.

    4. Prevent pg_dump scripts from being used to attack the user running the restore.

    5. Check for CREATE privileges on the schema in CREATE STATISTICS.

    6. Avoid integer overflow in allocation-size calculations within libpq.

    7. Guard against unexpected dimensions of oidvector/int2vector.

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

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

    10. Avoid incorrect complaint of invalid encoding when substring() is applied to “toasted” data. For further details, visit PostgreSQL’s release notes.

3. Key Features

  • Upgrade to PG 14.22 kernel: Feature #1223
    PostgreSQL kernel upgraded to version 14.22.

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

  • PostgreSQL Extensions
    Support for 7 Additional PostgreSQL Extensions: PostGIS, pgRouting, PGroonga, ddlx, pgsql-http, pgvector, pgvectorscale.

  • Global Unique Index: Feature #1230
    Offers a partition-table unique index that ensures cross-partition uniqueness using non-partition keys, available in both Postgres and Oracle compatibility modes, and supports create, attach, detach, insert, and update operations.

  • Rebuild view when column type changed in base table: Feature #1224
    When a column type change is executed, the database automatically saves the definitions of all dependent views and after completing the type change, rebuilds those views in the correct dependency order.

  • Logical Replication Fallback to FULL IDENTITY for Tables Without Primary Keys: Feature #1227
    Introduces a new GUC parameter logical_replication_fallback_to_full_identity that allows logical replication to automatically fall back to REPLICA IDENTITY FULL for tables configured with DEFAULT identity but lacking a primary key.

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

5. Contributors

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

  • Chao Li

  • David Zhang

  • Grant Zhou

  • Oreo Yang

  • Shuntian Jiao

  • Steven Niu

  • Xiaohui Liu

  • Xinjie LYU

  • Xueyu Gao

  • Zheng Tao

  • Zhenhao Pan

Complete Changelog