On Monday 03 March 2008 21:33:26 Bogumił Szady wrote: > Hi Postgis-Users, > > I have problem with postgresql 8.3 (postgis included), and the function > *geomunion*. When I use this function in my linux version (8.2) > everything works fine. I would like to union polygons from my view > "granice_view" into new view "dekanaty". > > CREATE OR REPLACE VIEW "public"."dekanaty" ( > gid, > dekanat, > the_geom) > AS > SELECT min(g.gid) AS gid, g.dekanat, > geomunion(g.the_geom) AS the_geom > FROM granice_view g > GROUP BY g.dekanat; > > This query works well on posrgresql 8.2 with postgis, but in the newer > version 8.3 I have the alert "OPERATION ON MIXED SRID GEOMETRIES". I > don't understand why - all srid numers in the "geometry_columns" are the > same and correct. Is that postgresql 8.3 error? > > Bogumil
Hi Bogumil, Can you provide a self-contained test case as a .sql file? And can you confirm the versions of PostgreSQL/PostGIS you are using? Many thanks, Mark. -- Mark Cave-Ayland Sirius Corporation - The Open Source Experts http://www.siriusit.co.uk T: +44 870 608 0063 _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
