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

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