GIN index statements are removed in generated SQL

Applies to

• Liquibase Secure (Pro)
• Liquibase Community (Open Source)

Conditions

• Using PostgreSQL
• Using Liquibase older than v4.32.0

Issue Summary

When using database inspection commands (such as `generate-changelog` and `diff-changelog`, etc.), Liquibase does not generate the correct SQL by removing the GIN indexes.

Error Message

There will not be an error message, but reviewing the generated SQL will confirm the missing GIN index statements. For example:

Native SQL:

CREATE INDEX "idx_details" ON "public"."users" USING GIN("test");

Generated SQL:

CREATE INDEX "idx_details" ON "users"("test");

Root Cause

The use of GIN indexes in PostgreSQL was not supported in versions before Liquibase v4.32.0.

Resolution

Update Liquibase to v4.32.0+.

The latest releases can be found on Liquibase.com and GitHub.