Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute" - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Date
Msg-id 3908.1273419752@sss.pgh.pa.us
Whole thread Raw
In response to Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"  (Ian Barwick <barwick@gmail.com>)
Responses Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
List pgsql-hackers
Ian Barwick <barwick@gmail.com> writes:
> 2010/5/9 David Fetter <david@fetter.org>:
>> A self-contained way to reproduce this, ideally small, would be
>> fantastic :)

s/fantastic/absolutely required to do anything with this report/

> I will see if I can knock together a reproducible test case, might
> take a day or so. At the moment all I can report is that creating a reduced
> version of the "object_version" table in a fresh DB with no data does
> not reproduce the error when running the above query.

It probably depends on a specific plan being chosen for the query,
and with no data loaded you'd most likely not get the same plan.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Ian Barwick
Date:
Subject: Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Next
From: Greg Stark
Date:
Subject: Re: max_standby_delay considered harmful