[postgis-users] Possible issue with Geos on PostgreSQL 8.0 NativeWindows

[TECHER Jean David]

Hi strk;

with postgresql 8.0.0 rc5 u have

postgis 0.9.1
geos 2.1.1
proj 4.4.9

i don't know for rc4
----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
Bureau: 04 67 45 60 27
Portable: 06 85 37 36 75
site perso : http://techer.pascal.free.fr/postgis/
site pro: http://www.01map.com/download/
K-S:"The greatest trick the devil pulled off was convincing people he didn't
exist"
------------------------------------------------------------
----- Original Message -----
From: <strk at refractions.net>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Wednesday, January 12, 2005 4:52 PM
Subject: Re: [postgis-users] Possible issue with Geos on PostgreSQL 8.0
NativeWindows


> 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