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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Дата
Msg-id 3908.1273419752@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"  (Ian Barwick <barwick@gmail.com>)
Ответы Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"  (Ian Barwick <barwick@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Ian Barwick
Дата:
Сообщение: Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Следующее
От: Greg Stark
Дата:
Сообщение: Re: max_standby_delay considered harmful