[postgis-users] Possible issue with Geos on PostgreSQL 8.0 Na tive Windows

[Obe, Regina DND\MIS]

GEOS 2.1.1

-----Original Message-----
From: strk at refractions.net [mailto:strk at refractions.net] 
Sent: Wednesday, January 12, 2005 10:52 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Possible issue with Geos on PostgreSQL 8.0
Native Windows


Which GEOS version ?
--strk;

On Wed, Jan 12, 2005 at 09:40:52AM -0500, Obe, Regina     DNDMIS wrote:
> 
> I was doing a trial port of my data from Cygwin PostGreSQL 7.4  
> Postgis 0.8
> 
> To Native Windows PostGreSQL  8.0.0 RC4, postgis 0.9.
> 
> 2 issues -  these could be caused by something wrong with my 
> reconfiguration since there are so many variables that have changed so 
> not sure if they are problems or not.  I just wanted to know if others 
> have run into similar issues.
> 
> When I was testing the geom_union function on one of my tables
> 
> On the cygwin install I get the following behavior
> 
> SELECT geomunion(the_geom) from neighborhood;
> 
> 
> results in Geos throwing the below error
> 
> ERROR:  GEOS union() threw an error!
> 
> NOTICE:  TopologyException: side location conflict 
> (780343,2.95405e+06)
> ---------------------------------------------------------
> 
> select geomunion(the_geom) from neighborhoods where name 
> IN('Dorchester', 'Charlestown');
> 
> Results in
> SRID=102686;MULTIPOLYGON(((778278.699002388  .........
> 
> ----------------------------------------------------------------------
> ------
> --------------------
> 
> Same Tests on the: Native Windows PostGreSQL  8.0.0 RC4, postgis 0.9. 
> (I'm using the PostGIS that came packaged with 8.0.0 RC4 official 
> release)
> --------------------------------------------------------
> 
> SELECT geomunion(the_geom) from neighborhood
> 
> Result: The postgres connection crashes without throwing an error so I 
> need to reconnect.
> 
> ----------------------------------------------------------------------
> ------
> -----
> select geomunion(the_geom) from neighborhoods where name IN('Dorchester',
> 'Charlestown');
> 
> Result - No SRID shows SRID=-1;MULTIPOLYGON(((778278.699002388
> 
> 
> Other functions such as collect for example return an SRID on both
installs
> and I checked the table and the geometry_columns table and both register
an
> SRID.
> 
> I tried reloading the table from the original shape file using the newer
> shp2pgsql and the same error still stands.
> 
> 
>  
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 

For standing up against patentability of software,

  Thank You, Poland!

Read the intervention:    http://kwiki.ffii.org/ConsPolon041221En
Send your thanks:         thankyoupoland.info
Read/do more:		  http://www.noepatents.org/
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users