This is a known issue which is fixed in the postgis-svn version. Use that instead of 1.3.2. I think 1.3.3 will be out soon too that will have the patch in it.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sebastian Reitenbach Sent: Friday, April 04, 2008 9:32 AM To: [email protected] Subject: [postgis-users] ERROR: Operation on mixed SRID geometries afterupgrading to recent postgres/postgis Hi all, I'm in the phase of evaluating an upgrade of postgres/postgis from 8.1.4/1.1.2 to 8.3.X/1.3.2. But while testing, I ran into trouble with one of the queries that worked before Now I have postgresql-8.3.1.tar.bz2 or postgresql-8.3.0.tar.bz2, and proj-4.6.0.tar.gz, postgis-1.3.2.tar.gz, and geos-3.0.0.tar.bz2 installed. With the old database/postgis version constellation (geos-2.2.2.tar.bz2, postgis-1.1.2.tar.gz, proj-4.4.9.tar.gz, and postgresql-8.1.4.tar.bz2) the query below worked: select "TILE_ID", innerst_shape from (select original_tile."UNIQUE_ID", original_tile."TILE_ID", original_tile."TILE_INTERIOR_SHAPE", original_tile."TILE_POLY_SHAPE", difference(original_tile."TILE_INTERIOR_SHAPE", geomunion(intersect_tile."TILE_POLY_SHAPE")) as innerst_shape FROM "tile" original_tile JOIN "tile" intersect_tile ON (intersect_tile."TILE_ID"!= original_tile."TILE_ID" AND intersect_tile."TILE_POLY_SHAPE" && original_tile."TILE_INTERIOR_SHAPE" and Intersects(intersect_tile."TILE_POLY_SHAPE", original_tile."TILE_INTERIOR_SHAPE") and round(intersect_tile."TILE_ID"/100000)<=round(original_tile."TILE_ID"/10 0000)) WHERE original_tile."TILE_ID" in (select "TILE_ID" from "tile" where "TILE_POLY_SHAPE"&& GeomFromText('POLYGON((75.7491342 31.0239757,75.7473798 30.7984119,76.0086717 30.7966414,76.0110403 31.02219,75.7491342 31.0239757))', 4326) and Intersects ("TILE_POLY_SHAPE", GeomFromText('POLYGON((75.7491342 31.0239757,75.7473798 30.7984119,76.0086717 30.7966414,76.0110403 31.02219,75.7491342 31.0239757))', 4326)) ) GROUP BY original_tile."UNIQUE_ID", original_tile."TILE_ID", original_tile."TILE_INTERIOR_SHAPE", original_tile."TILE_POLY_SHAPE") as subquery where not IsEmpty(innerst_shape) and Intersects(innerst_shape, GeomFromText('POLYGON((75.7491342 31.0239757,75.7473798 30.7984119,76.0086717 30.7966414,76.0110403 31.02219,75.7491342 31.0239757))', 4326)) and not Touches(innerst_shape, GeomFromText('POLYGON((75.7491342 31.0239757,75.7473798 30.7984119,76.0086717 30.7966414,76.0110403 31.02219,75.7491342 31.0239757))', 4326)) ERROR: Operation on mixed SRID geometries ********** Error ********** ERROR: Operation on mixed SRID geometries SQL state: XX000 this worked with the old versin, without glitch. So anybody has an idea what this error message mean, and more importantly how to overcome it? kind regards Sebastian _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
