Using a full text index with PostgreSQL and Doctrine
0
votes
1
answer
1204
views
I received the following error:
SQLSTATE: Program limit exceeded: 7 ERROR: index row size 2728 exceeds btree version 4 maximum 2704 for index "fulltext"
DETAIL: Index row references tuple (1,33) in relation "manual".
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing. (54000) class: PDOException
The table in question is:
\d manual
Table "public.manual"
Column | Type | Collation | Nullable | Default
--------------+-----------------------+-----------+----------+------------------------------------
id | integer | | not null | nextval('manual_id_seq'::regclass)
parent_id | integer | | |
name | character varying(45) | | not null |
content | text | | |
keywords | text | | |
listorder | smallint | | |
display_list | boolean | | |
Indexes:
"manual_pkey" PRIMARY KEY, btree (id)
"unique_name_manual" UNIQUE, btree (name)
"fulltext" btree (keywords, name, content)
"idx_10dbbec4727aca70" btree (parent_id)
Foreign-key constraints:
"fk_10dbbec4727aca70" FOREIGN KEY (parent_id) REFERENCES manual(id)
Referenced by:
TABLE "manual" CONSTRAINT "fk_10dbbec4727aca70" FOREIGN KEY (parent_id) REFERENCES manual(id)
I thought I had a full text index per my Doctrine config ``, but it appears I don't. Am I doing something wrong or is a Doctrine deficiency? Recommended solutions?
Asked by user1032531
(153 rep)
May 12, 2020, 12:50 PM
Last activity: Apr 20, 2025, 09:03 PM
Last activity: Apr 20, 2025, 09:03 PM