BUG #16986: reindex error on ltree index
От | PG Bug reporting form |
---|---|
Тема | BUG #16986: reindex error on ltree index |
Дата | |
Msg-id | 16986-1a4dfbef2c4e5a16@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #16986: reindex error on ltree index
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 16986 Logged by: Mauro Valletta Email address: mauro@enuan.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
В списке pgsql-bugs по дате отправления: