Re: SRID conflict, PostgreSQL 8.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: csmith <csmith(at)insequenceinc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SRID conflict, PostgreSQL 8.3
Date: 2009-03-21 00:31:16
Message-ID: 12431.1237595476@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

csmith <csmith(at)insequenceinc(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randall Lucas 2009-03-21 00:37:33 Defer a functional index calculation?
Previous Message DM 2009-03-20 22:40:39 pg_restore error - Any Idea?