> > 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).
>
>
=?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> =?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= <[EMAIL PROTECTED]> 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 us
Tom Lane wrote:
>
> =?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= <[EMAIL PROTECTED]> 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 whe
=?iso-8859-1?Q?Lo=EFc=20TREGOU=CBT?= <[EMAIL PROTECTED]> 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 al
Hello,
When i try to create a index (btree on text field) after a restore i've
the
following error :
FATAL 1: btree: failed to add item to the page in _bt_sort (2)
But , if i had some rows on this table , the index creation works fine !
The table contains 1 million rows.
I've tried a l
Bruce Momjian wrote:
> > Hi,
> >I want to create a index with 8 items, but postgresql report an error
> > message. (arguement 8>7?)
> > do postgressql can only create a index with max. 7 items?
>
> Yes.
So what can we do about it? (Besides changing the data model!)
Can postgres be configu
> Hi,
>I want to create a index with 8 items, but postgresql report an error
> message. (arguement 8>7?)
> do postgressql can only create a index with max. 7 items?
Yes.
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROTECTED]| (610) 853-3000
Hi,
I want to create a index with 8 items, but postgresql report an error
message. (arguement 8>7?)
do postgressql can only create a index with max. 7 items?
