Skip to main content

IvorySQL Release - 1.2


Release Notes

[Release Date: February 28, 2022]


IvorySQL 1.2 is based on PostgreSQL 14.2 and contains a variety of fixes and new feature from IvorySQL 1.1. For information about new features in major release 1.0, see IvorySQL 1.0 release notes.

This release is compatible with IvorySQL 1.1 and does not require a dump/restore for those running IvorySQL 1.1

However, a couple of bug have been fixed in PostgreSQL 14.2 around possible index corruption (See first and the second change-log entries of PostgreSQL 14.2 change-log ), If any of those cases apply to you, It is recommended to reindex the affected indexes after updating to IvorySQL 1.2

For updates and bug fixes in PostgreSQL 14.2 please refer to Official PostgreSQL release notes of 14.2.


  • Support for Hierarchical Queries.
    Hierarchical queries allow to select rows in a hierarchical order using the hierarchical query clause for tables that contains the hierarchical data.

  • Bug fixes

  • Fixed an issue with Package Array type variables losing value after first execution.
    issue details

  • Fixed an issue with Package functions fails to use user defined type as their return type.
    issue details


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

  • Asif Rehman
  • Grant Zhou
  • Jack Lan
  • Shengbin Zhao
  • Muhammad Usama

Complete Changelog