Missing GIN support function (4 or 6) for attribute 1 of index
0
votes
1
answer
69
views
I have a problem creating GIN indexes in postgres 14.9 and GIN 1.3
The following is the query:
CREATE TABLE assert.test_gin(col1 func.doc_sub_type[]);
CREATE INDEX ON assert.test_gin USING gin(col1);
And here is the results of running the above:
ERROR: missing GIN support function (4 or 6) for attribute 1 of index "test_gin_col1_idx"
SQL state: XX000
I check pg_catalog and public schema GIN support functions. 4 and 6 are according to the documentation (https://www.postgresql.org/docs/current/gin-extensibility.html) are bool consistent and GinTernaryValue triConsistent respectively, which both exist in my pg_catalog but not in public schema.
Please help!!!!!
Asked by Ali Azimi
(1 rep)
Jan 15, 2024, 03:19 PM
Last activity: Jan 15, 2024, 04:21 PM
Last activity: Jan 15, 2024, 04:21 PM