BUG #16986: reindex error on ltree index

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: mauro(at)enuan(dot)com
Subject: BUG #16986: reindex error on ltree index
Date: 2021-04-29 09:59:46
Message-ID: 16986-1a4dfbef2c4e5a16@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 16986
Logged by: Mauro Valletta
Email address: mauro(at)enuan(dot)com
PostgreSQL version: 12.6
Operating system: Ubuntu 20.04.2
Description:

Hi
reindexing a table with ltree index this error is thrown:
ERROR: index row size 7720 exceeds maximum 8152 for index
"ltree_test_session_event_path_idx"
Follow script to reproduce error:
---------------------------------------------------------------
CREATE TABLE "m3_dm"."ltree_test" (
"session_id" varchar COLLATE "pg_catalog"."default" NOT NULL,
"session_event_path" "public"."ltree",
CONSTRAINT "ltree_test_pkey" PRIMARY KEY ("session_id")
);
CREATE INDEX "ltree_test_session_event_path_idx" ON "m3_dm"."ltree_test"
USING gist (
"session_event_path" "public"."gist_ltree_ops"
);
insert into m3_dm.ltree_test
values (
'aaa',
text2ltree(repeat('abcdefghi.',480)||'abcdefghi')
)
;
reindex table m3_dm.ltree_test;
---------------------------------------------

Regards
Mauro

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2021-04-29 10:49:15 BUG #16988: Spurious "SET LOCAL can only be used in transaction blocks" warning using implicit transaction block
Previous Message Stephen Frost 2021-04-28 18:23:07 Re: Bug in handling default privileges inside extension update scripts