Description

Advanced indexes like GIN in PostgreSQL are not displayed in the index column of HeidiSQL. This significantly limits PostgreSQL usage within the software, as users cannot view complete information about the indexes created in the database.

For example:
When running the following SQL command:

CREATE INDEX eans_name_pt_idx ON eans USING gin (to_tsvector('portuguese', name));

The index does not appear in the index column of HeidiSQL.

Steps to Reproduce:

Steps to Reproduce:

1 - Connect to a PostgreSQL database containing advanced indexes like GIN.
2 - Create an index using the command above or similar.
3 - Navigate to the index section in HeidiSQL.
4 - Observe that the advanced index does not appear in the list.

Expected Behavior:

HeidiSQL should display all indexes created in the database, including advanced indexes like GIN, in the index column.

Actual Behavior:

The index column fails to display advanced indexes such as GIN.

Additional Information:

• Database Type and Version: PostgreSQL 17
• HeidiSQL Version: 12.10.0.7027
• Operating System: Windows 11 Pro

HeidiSQL version

12.10.0.7027

Database server version

Postgres 17

Reproduction recipe

CREATE INDEX eans_name_pt_idx ON eans USING gin (to_tsvector('portuguese', name));

Error/Backtrace