Re: index row size exceeds btree maximum, 2713 - Solutions? - Mailing list pgsql-general

From Jaime Casanova
Subject Re: index row size exceeds btree maximum, 2713 - Solutions?
Date
Msg-id c2d9e70e0507181327767662a7@mail.gmail.com
Whole thread Raw
In response to index row size exceeds btree maximum, 2713 - Solutions?  (Dan Armbrust <daniel.armbrust.list@gmail.com>)
List pgsql-general
> I'm trying to load some data into PostgreSQL 8.0.3, and I got the error
> message "index row size 2904 exceeds btree maximum, 2713".  After a
> bunch of searching, I believe that I am getting this error because a
> value that I am indexing is longer than ~ 1/3 of the block size - or the
> BLCKSZ variable in the src/include/pg_config_manual.h file.
>
> Am I correct so far?
>
> I need to fix this problem.  I cannot change the indexed columns.
>

can you drop the index and retry?
what typo is the column?



--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-general by date:

Previous
From: Dan Armbrust
Date:
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?
Next
From: Jaime Casanova
Date:
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?