Index item size 4496 exceeds maximum 2713

From: Jon Hassen <jhassen(at)azstarnet(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Index item size 4496 exceeds maximum 2713
Date: 2002-03-04 22:18:33
Message-ID: B8A940C9.D1E%jhassen@azstarnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

When I try and create an index on a text field, I get this response:

"ERROR: btree: index item size 4496 exceeds maximum 2713"

On another PGSQL database I only got that message when the size was above
8192. How can I change my database to use the full 8192 size? Or how can I
get around this problem at all?

If you answer, would you please send the response to my email address as
well as to this list? Please?

Thanks,

Jon Hassen
jhassen(at)azstarnet(dot)com

Browse pgsql-novice by date

  From Date Subject
Next Message Joshua b. Jore 2002-03-04 22:44:58 Re: Do Stored Procedures exist (Besides FUNCTIONs)
Previous Message Oliver Elphick 2002-03-04 21:33:07 Re: Primary Key problem