Sample Header Ad - 728x90

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