Re: [HACKERS] FATAL 1:btree: items are out of order - Mailing list pgsql-hackers

From Vadim B. Mikheev
Subject Re: [HACKERS] FATAL 1:btree: items are out of order
Date
Msg-id 2bab9c1894ebd3026a2c95b9d861b06a
Whole thread Raw
List pgsql-hackers
Michael Reifenberger wrote:
>
> On Fri, 6 Jun 1997, Vadim B. Mikheev wrote:
> ...
> > BTW, there shouldn't be problems in using btree for variable
> > length attributes if there are no duplicates... Michael, are there
> > duplicates in your table ?
> >
>
> Yes.
>
> If there is a bug regarding dublicates and btrees, why does work a:
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
btree + variable-length attributes + duplicates

> CREATE TABLE ...
> COPY ... FROM ...
> CREATE INDEX ...
>
> Does this bug occure only during inserts.

Yes (I hope) - bulkload code don't split pages.

>
> If the bug can't be fixed for 6.1 then he should be documented.
> (Any chance to reproduce it in a regression test?)
>
> PS: Do you still need my debugging-info you requested before?

No, but please try run new posted code (with checks after PageAddItem) -
I'm interested in FATAL message in your case.

Vadim

------------------------------

pgsql-hackers by date:

Previous
From: Michael Reifenberger
Date:
Subject: Re: [HACKERS] FATAL 1:btree: items are out of order
Next
From: David Friend
Date:
Subject: [HACKERS] TZ environment variable