[postgis-users] Postgresql 8.3 on windows and geomunion

[Mark Cave-Ayland]

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