Postgres: Access method "gin" does not support ASC/DESC options
Chase Roden 4 years ago • updated by Adam Mościcki 4 years ago • 1
When I create an index that uses the GIN access method, Vertabelo requires me to choose ASC or DESC:
-- 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);
Customer support service by UserEcho
As for now, please use "Additional SQL scripts" section.
We need to think how to support it.