0
Planned

Postgres: Access method "gin" does not support ASC/DESC options

Chase Roden 5 years ago updated by Adam Mościcki 5 years ago 1

When I create an index that uses the GIN access method, Vertabelo requires me to choose ASC or DESC:

Image 739

-- which GIN does not support. So the generated SQL DDL says (e.g.):

CREATE INDEX test_table_idx_1 on schema.test_table USING gin (column_2 ASC);

If I don't manually remove the "ASC" from generated code, Postgres will not run the statement, returning

access method "gin" does not support ASC/DESC options

I would like to be able to unset the ASC/DESC option and have the generated SQL not include the index order when it's not compatible with the access method, so that the generated SQL looks like:

CREATE INDEX test_table_idx_1 on schema.test_table USING gin (column_2);

+1
Planned

Hello,

As for now, please use "Additional SQL scripts" section.

We need to think how to support it.

Best regards,

Adam Mościcki