Sample Header Ad - 728x90

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