Re: index row size exceeds btree maximum, 2713 - Solutions?

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: Dan Armbrust <daniel(dot)armbrust(dot)list(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?
Date: 2005-07-18 20:27:51
Message-ID: c2d9e70e0507181327767662a7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ;)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jaime Casanova 2005-07-18 20:32:33 Re: index row size exceeds btree maximum, 2713 - Solutions?
Previous Message Dan Armbrust 2005-07-18 20:17:35 Re: index row size exceeds btree maximum, 2713 - Solutions?