Re: SRID conflict, PostgreSQL 8.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: SRID conflict, PostgreSQL 8.3
Дата
Msg-id 12431.1237595476@sss.pgh.pa.us
обсуждение исходный текст
Ответ на SRID conflict, PostgreSQL 8.3  (csmith <csmith@insequenceinc.com>)
Список pgsql-general
csmith <csmith@insequenceinc.com> writes:
> ... It's as if the
> query is considering tuples in "catalog" outside of the view's domain.

This isn't particularly surprising: the planner will feel free to push
that WHERE condition down as far as it can.  Probably there is some
aspect of the view definition that prevented such an optimization in
prior versions but doesn't deter 8.3.  You didn't show us the view
though, nor any EXPLAIN output ...

            regards, tom lane

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

Предыдущее
От: "Brent Wood"
Дата:
Сообщение: Re: SRID conflict, PostgreSQL 8.3
Следующее
От: Randall Lucas
Дата:
Сообщение: Defer a functional index calculation?