<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1607" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>On Monday 03 March 2008 21:33:26 Bogumil Szady
wrote:<BR>> Hi Postgis-Users,<BR>><BR>> I have problem with postgresql
8.3 (postgis included), and the function<BR>> *geomunion*. When I use this
function in my linux version (8.2)<BR>> everything works fine. I would like
to union polygons from my view<BR>> "granice_view" into new view
"dekanaty".<BR>><BR>> CREATE OR REPLACE VIEW "public"."dekanaty"
(<BR>> gid,<BR>> dekanat,<BR>>
the_geom)<BR>> AS<BR>> SELECT min(g.gid) AS gid,
g.dekanat,<BR>> geomunion(g.the_geom) AS the_geom<BR>> FROM
granice_view g<BR>> GROUP BY g.dekanat;<BR>><BR>> This query works well
on posrgresql 8.2 with postgis, but in the newer<BR>> version 8.3 I have the
alert "OPERATION ON MIXED SRID GEOMETRIES". I<BR>> don't understand why - all
srid numers in the "geometry_columns" are the<BR>> same and correct. Is that
postgresql 8.3 error?<BR>><BR>> Bogumil<BR><BR>I've run into the same
problem, plus a few others that didn't show in 8.2,<BR>using postgresql 8.3.0
along with PostGIS 1.3.2 on MS Windows. I not<BR>familiar enough to write
a self-contained sql test case so I'll try and<BR>describe what I'm seeing and
hope for the best.<BR><BR>On the initial install everything seems to go well
except plpythonu fails to<BR>install due to an inability to find the dll which,
after the install, is<BR>present in the /lib directory.<BR><BR>To familiarize
myself with PostGIS I tried running through Boston GIS's<BR>tutorial at <A
href="http://www.bostongis.com/?content_name=postgis_tut01#20">http://www.bostongis.com/?content_name=postgis_tut01#20</A>
and hit<BR>an error when trying to run shp2pgsql. The executable looks
for<BR>libiconv-2.dll which, while the correct file name for 8.2, in 8.3 the
file<BR>is name libiconv2.dll. Creating a copy with the 8.2 naming style appears
to<BR>fix the problem.<BR><BR>Executing the sample statement "select
area(geomunion(the_geom)) from towns<BR>where town = 'BOSTON';" gives an "ERROR:
Operation on mixed SRID geometries<BR>SQL state: XX000". Running a quick
"select distinct srid(the_geom) from<BR>towns;" shows that all rows are set to
srid 26986.<BR><BR>Brad
<DIV><FONT face=Arial size=2></FONT> </DIV></BODY></HTML>