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

From: robert(dot)thaler(at)cellent(dot)at
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #12292: index row size 1480 exceeds maximum 1352 for index
Date: 2014-12-20 19:27:30
Message-ID: 20141220192730.11502.42806@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 12292
Logged by: robert thaler
Email address: robert(dot)thaler(at)cellent(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message dlazerka 2014-12-21 05:33:42 BUG #12300: ~/.psql_history nonexistent warning on first run
Previous Message David G Johnston 2014-12-20 19:06:32 Re: BUG #12290: select all columns data except one column