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
Last activity: Mar 2, 2023, 07:37 PM