ERROR: failed to add item to the index page

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема ERROR: failed to add item to the index page
Дата
Msg-id VisenaEmail.c5.3ee7fe277d514162.16a6d785bea@tc7-visena
обсуждение исходный текст
Ответы Re: ERROR: failed to add item to the index page
Список pgsql-hackers
Дерево обсуждения
With master (3dbb317d32f4f084ef7badaed8ef36f5c9b85fe6) I'm getting this:
 
visena=# CREATE INDEX origo_email_part_hdrvl_value_idx ON public.origo_email_part_headervalue USING btree (lower(substr((header_value)::text, 0, 1000)) varchar_pattern_ops); 
psql: ERROR:  failed to add item to the index page
 
The schema looks like this:
create table origo_email_part_headervalue
(   entity_id    BIGSERIAL PRIMARY KEY,   version      int8    not null,   header_value varchar NOT NULL,   header_id    int8 references origo_email_part_header (entity_id),
    value_index  int     NOT NULL DEFAULT 0,   UNIQUE (header_id, value_index)
);

CREATE INDEX origo_email_part_hdrvl_hdr_id_idx ON origo_email_part_headervalue (header_id);
CREATE INDEX origo_email_part_hdrvl_value_idx ON origo_email_part_headervalue (lower(substr(header_value, 0, 1000)) varchar_pattern_ops);

(haven't tried any other version so I'm not sure when this started to happen)

--
Andreas Joseph Krogh
 

В списке pgsql-hackers по дате отправления: