[postgis-users] Postgresql 8.3 on windows and geomunion

[Mark Cave-Ayland]

On Wednesday 05 March 2008 03:56:14 Sanglant wrote:

> I've run into the same problem, plus a few others that didn't show in 8.2,
> using postgresql 8.3.0 along with PostGIS 1.3.2 on MS Windows.  I not
> familiar enough to write a self-contained sql test case so I'll try and
> describe what I'm seeing and hope for the best.
>
> On the initial install everything seems to go well except plpythonu fails
> to install due to an inability to find the dll which, after the install, is
> present in the /lib directory.
>
> To familiarize myself with PostGIS I tried running through Boston GIS's
> tutorial at http://www.bostongis.com/?content_name=postgis_tut01#20 and hit
> an error when trying to run shp2pgsql.  The executable looks for
> libiconv-2.dll which, while the correct file name for 8.2, in 8.3 the file
> is name libiconv2.dll. Creating a copy with the 8.2 naming style appears to
> fix the problem.
>
> Executing the sample statement "select area(geomunion(the_geom)) from towns
> where town = 'BOSTON';" gives an "ERROR: Operation on mixed SRID geometries
> SQL state: XX000".  Running a quick "select distinct srid(the_geom) from
> towns;" shows that all rows are set to srid 26986.
>
> Brad


Hi Brad,

Thanks for the report. I've added this to the known issues/patches section of 
the PostGIS wiki, so it's on the queue to be reviewed during the next 
development cycle.

I really can't get into the Google Bug Tracker at all :( 


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063