Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"

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