BUG #12292: index row size 1480 exceeds maximum 1352 for index

Поиск
Список
Период
Сортировка
От robert.thaler@cellent.at
Тема BUG #12292: index row size 1480 exceeds maximum 1352 for index
Дата
Msg-id 20141220192730.11502.42806@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #12292: index row size 1480 exceeds maximum 1352 for index
Re: BUG #12292: index row size 1480 exceeds maximum 1352 for index
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      12292
Logged by:          robert thaler
Email address:      robert.thaler@cellent.at
PostgreSQL version: 9.4.0
Operating system:   linux ubuntu 14.04.1 LTS x86_64
Description:

I tried to upgrade from postgres 9.3.5 and imported a database export
created by pg_dump. the import shows the following error:
ERROR: index row size 1480 exceeds
maximum 1352 for index "idx_sm_post_content"

manually creating the gin index for fulltext search does not work too and
produces the same error.

create index idx_sm_post_content
on client.sm_post using gin (to_tsvector('english', "content"))

on postgres 9.3.5 creating the index on the same data works fine.

kind regards

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

Предыдущее
От: alex
Дата:
Сообщение: Re: segfault on query
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #12292: index row size 1480 exceeds maximum 1352 for index