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-05 00:27:59
Message-ID: B8A95F1F.D20%jhassen@azstarnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2002-03-05 00:30:34 Re: index item size 4496 exceeds maximum 2713
Previous Message Joshua b. Jore 2002-03-04 22:44:58 Re: Do Stored Procedures exist (Besides FUNCTIONs)