| 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: | Whole Thread | Raw Message | 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
| 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 |