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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ian Barwick <barwick(at)gmail(dot)com>
Cc: David Fetter <david(at)fetter(dot)org>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Date: 2010-05-09 15:42:32
Message-ID: 3908.1273419752@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Ian Barwick <barwick(at)gmail(dot)com> writes:
> 2010/5/9 David Fetter <david(at)fetter(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2010-05-09 16:47:51 Re: max_standby_delay considered harmful
Previous Message Ian Barwick 2010-05-09 15:20:46 Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"