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

Поиск
Список
Период
Сортировка
От Ian Barwick
Тема 9.0b1: "ERROR: btree index keys must be ordered by attribute"
Дата
Msg-id j2g1d581afe1005090148t904c3cbaia92e5e66ecfdb255@mail.gmail.com
обсуждение исходный текст
Ответы Re: 9.0b1: "ERROR: btree index keys must be ordered by attribute"  (David Fetter <david@fetter.org>)
Список pgsql-hackers
Hi

I've just compiled the 9.0 beta1 source tarball and am testing my
custom application against it (which has been running on PostgreSQL
since 7.3 or so).

The below statement results in the following error message:
 "ERROR:  btree index keys must be ordered by attribute"

evidently in relation to the subselect. The statement works fine on
previous versions up to 8.4.3. I can provide more details later if
required:
   SELECT o.object_id     FROM object o       INNER JOIN class c               ON (o.class_id = c.class_id)       INNER
JOINobject_version ov               ON (o.object_id = ov.object_id)       INNER JOIN site               ON
(o.site_id=site.site_id)           WHERE o.object_id = '3143'              AND ov.version = '0'              AND
o.site_id= '2'              AND ov.object_status_id = (SELECT MAX(ov1.object_status_id)                   FROM
object_versionov1                  WHERE o.object_id=ov1.object_id                    AND ov1.version = ov.version
             AND ov1.lang = ov.lang                 )            AND ov.lang = 'en'
 


SELECT version():
PostgreSQL 9.0beta1 on i686-pc-linux-gnu, compiled by GCC gcc (Ubuntu
4.3.2-1ubuntu12) 4.3.2, 32-bit
Ubuntu 8.10 running on a "VIA C7-M" Processor  (netbook).

Regards

Ian Barwick


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: max_standby_delay considered harmful
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: max_standby_delay considered harmful