BUG #12292: index row size 1480 exceeds maximum 1352 for index - Mailing list pgsql-bugs

From robert.thaler@cellent.at
Subject BUG #12292: index row size 1480 exceeds maximum 1352 for index
Date
Msg-id 20141220192730.11502.42806@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #12292: index row size 1480 exceeds maximum 1352 for index
Re: BUG #12292: index row size 1480 exceeds maximum 1352 for index
List 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 by date:

Previous
From: alex
Date:
Subject: Re: segfault on query
Next
From: Tom Lane
Date:
Subject: Re: BUG #12292: index row size 1480 exceeds maximum 1352 for index