Re: SRID conflict, PostgreSQL 8.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: SRID conflict, PostgreSQL 8.3
Date
Msg-id 12431.1237595476@sss.pgh.pa.us
Whole thread Raw
In response to SRID conflict, PostgreSQL 8.3  (csmith <csmith@insequenceinc.com>)
List 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 by date:

Previous
From: "Brent Wood"
Date:
Subject: Re: SRID conflict, PostgreSQL 8.3
Next
From: Randall Lucas
Date:
Subject: Defer a functional index calculation?