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.
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.
-
Fix QL code bin: https://github.com/IvorySQL/IvorySQL
-
IvorySQL blog bin: https://github.com/IvorySQL/Ivory-www