Re: Create index problem ( _bt_sort ) - Mailing list pgsql-admin

From Tom Lane
Subject Re: Create index problem ( _bt_sort )
Date
Msg-id 25101.980788813@sss.pgh.pa.us
Whole thread Raw
In response to Re: Create index problem ( _bt_sort )  (Loïc TREGOUËT <loic@cri74.org>)
List pgsql-admin
=?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= <loic@cri74.org> writes:
> Tom Lane wrote:
>> =?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= <loic@cri74.org> writes:
> raslog=# create index user2000 on log2000(username);
> FATAL 1:  btree: failed to add item to the page in _bt_sort (2)
>>
>> How long are the usernames?  IIRC, 7.0.* has some edge cases that might
>> fail when items approach the maximum allowed size of 1/3 page (~ 2700
>> bytes).

> The maximum length , is about 40 character (but not 2700 bytes).

Hmm, then it's not what I thought.  Would you be willing to send me
a pg_dump of that table?  (Don't send it to the whole list!)

            regards, tom lane

pgsql-admin by date:

Previous
From: R D
Date:
Subject: Re: Tuple problem
Next
From: "Graham Vickrage"
Date:
Subject: RE: pg_hba.conf question