Re: [GENERAL] SRID conflict, PostgreSQL 8.3

2009-03-20 Thread Tom Lane
csmith 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 suc

Re: [GENERAL] SRID conflict, PostgreSQL 8.3

2009-03-20 Thread Brent Wood
This should be addressed to the Postgis list. However, you are spatially joining two geometries, and they need be in the same coordinate system. The column "the_geom" has a defined SRID (spatial reference id) when created in it's original table. Your hard coded POLYGON in the SQL below has a SR

[GENERAL] SRID conflict, PostgreSQL 8.3

2009-03-20 Thread csmith
Hello, I serve a Geospatial IS project that for some years has used PostgreSQL and PostGIS. A strategy/scheme that has worked for all previous versions has failed with a recent upgrade to 8.3 (e.g. 8.3.6-1). Relation "catalog" is a large geospatially-enabled aggregation of data with a varie