Sample Header Ad - 728x90

ERROR: data type text[] has no default operator class for access method "gist"

4 votes
2 answers
3241 views
Whenever I try to try to create a GIST index on text[], I get the above error. CREATE TABLE bar(f) AS VALUES (ARRAY['foo','bar','baz']); CREATE INDEX ON bar USING gist(f); ERROR: data type text[] has no default operator class for access method "gist" HINT: You must specify an operator class for the index or define a default operator class for the data type. I'm trying to [create an *Exclusion Constraint*](https://dba.stackexchange.com/a/185177/2639) on bar, so I need a GIST index.
Asked by Evan Carroll (65502 rep)
Sep 6, 2017, 09:37 AM
Last activity: Mar 2, 2023, 07:37 PM