From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: mauro@enuan.com
Subject: BUG #16986: reindex error on ltree index
Date: Thu, 29 Apr 2021 09:59:46 +0000
Message-ID: <16986-1a4dfbef2c4e5a16@postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, mauro@enuan.com
Subject: Re: BUG #16986: reindex error on ltree index
In-Reply-To: <16986-1a4dfbef2c4e5a16@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox