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

From Bruce Momjian
Subject Re: [HACKERS] FATAL 1:btree: items are out of order
Date
Msg-id 143ce5e16b9e2005efb8371f5b80ac02
Whole thread Raw
List pgsql-hackers
> > There is no time to fix it now. I'll try to do it latter.
> >
> > ...Original Lehman and Yao algorithm doesn't allow duplicates at all.
> > Old team added some hacks... and we have to add yet more...
> >
> > 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 ?
> >
> > Marc, did you use btree for variable length attributes?
> > Do you have duplicates ?
>
>     Assuming you mean varchar()?  No, all my attributes are of text...
> but, then again, I guess that means variable lenght, eh? :(  Yes, my
> indices are based on variable length attributes...
>
>     As for duplicates...the most likely are duplicates for each
> 'indexed field'..
>

The only thing I want to know is, "Do we need to add this to the TODO
bugs section, so people know this doesn't work, or is this a rare thing?"

- --
Bruce Momjian
maillist@candle.pha.pa.us

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

pgsql-hackers by date:

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