1. Versions Introduction

[Release Date: June 28, 2022]

IvorySQL 1.4 is based on PostgreSQL 14.4 and includes various fixes and new features from IvorySQL 1.3.

This version is compatible with IvorySQL 1.3 and does not require data backup/restore for users running IvorySQL 1.X.

It includes various fixes from 14.3, in particular fixes for CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY, which could cause unprompted data corruption for indexes. Until fixed, CREATE INDEX CONCURRENTLY and REINDEX CONCURRENTLY can build indexes with missing entries, causing SELECT queries using that index to not find certain rows. More details can be found in 14.4 release.

If you have any indexes created using the CONCURRENTLY option under 14.X, you should re-index them after updating. See the first change entry in PostgreSQL 14.4 Release Notes.

For updates and bug fixes in PostgreSQL 14.4, see the official PostgreSQL 14.4 Release Notes.

2. Feature Introduction

  • Fixes various issues caused by version upgrade updates.

3. Known issues

  • Crash caused by using pseudo-columns.

4. Fixed issues

  • Fixed package permission issue details

5. Source Code

IvorySQL contains 2 main code repositories, the database IvorySQL code bin, and the IvorySQL blog bin.

6. Contributors

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

  • Asif Rehman

  • Grant Zhou

  • Shengbin Zhao

  • Muhammad Usama