Re: Create index problem ( _bt_sort )

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).
> 
> Would you be willing to try the example in 7.1beta4?
> 
>                         regards, tom lane

The maximum length , is about 40 character (but not 2700 bytes).
What do you think about this :
when i have add some rows , the index creation become possible . It's
strange , isn't it ? I don't remove any row .
I work on a debien and i like the system package so, for the 7.1beta4, 
i will try if i'm forced .

	Thanks , soory for my english
-- 
Loïc  TREGOUËT