[postgis-users] ERROR: Operation on mixed SRID geometries afterupgrading to recent postgres/postgis

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Sebastian Reitenbach
Sent: Friday, April 04, 2008 9:32 AM
To: postgis-users at postgis.refractions.net
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
postgis-users at postgis.refractions.net
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.