Cannot use siglen parameter while creating index gist_trgm_ops in PostgreSQL 11.19 (Azure flexible DB)

Question

When trying to create index on remote Azure server (PostgreSQL 11.19 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.5.0-3ubuntu1~18.04) 7.5.0, 64-bit) create index test on "Table" using gist("Name" gist_trgm_ops(siglen=256)); with custom siglen parameter I see syntax error in console

ERROR: syntax error at or near "(" LINE 2: using gist("VariationName" gist_trgm_ops(siglen=256)); ^

SQL state: 42601 Character: 92

But if I try to execute this code on my local machine with local server (PostgreSQL 15.3, compiled by Visual C++ build 1914, 64-bit) there is no error.

What version of PostgreSQL supports siglen in indexes or what setting I can change in Azure to resolve this issue?

I tried to change some sttings on Azure flixible server side but didn't succeeded with that.

You are right. That's about TRGM extension postgresql.org/docs/current/pgtrgm.html — Anton Chaika
– Anton Chaika, Commented Aug 2, 2023 at 13:16

Anton Chaika · Accepted Answer · 2023-08-02 14:09:02Z

1

I found the answer. You need to use PostgreSQL 13+ in order to create gist_trgm_ops indexes with custom siglen parameter.

answered Aug 2, 2023 at 14:09

Anton Chaika

213 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot use siglen parameter while creating index gist_trgm_ops in PostgreSQL 11.19 (Azure flexible DB)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related