[postgis-users] Quick Note for XP Home UsersandWin32PostgreSQL8.0 beta 1 installer

[TECHER Jean David]

Hi Mark

Did you made some tests such as Intersects(), interserction, area(),
geomunion() jus to see

fisrt test should be to try PointOnSurface()...

if everything is OK.... :-)

----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site: http://techer.pascal.free.fr/postgis/
------------------------------------------------------------
----- Original Message -----
From: "Mark Cave-Ayland" <m.cave-ayland at webbased.co.uk>
To: "'PostGIS Users Discussion'" <postgis-users at postgis.refractions.net>
Sent: Tuesday, October 12, 2004 12:17 PM
Subject: RE: [postgis-users] Quick Note for XP Home
UsersandWin32PostgreSQL8.0 beta 1 installer



> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On
> Behalf Of strk at refractions.net
> Sent: 06 October 2004 12:51
> To: 'PostGIS Users Discussion'
> Subject: Re: [postgis-users] Quick Note for XP Home Users
> andWin32PostgreSQL8.0 beta 1 installer
>
>
> On Wed, Oct 06, 2004 at 12:40:33PM +0100, Mark Cave-Ayland wrote:
> (cuts)
> > I think when Dave (Blasby) looked into this to begin with
> it was a bug
> > in glibc.... Does anyone know whether this has been fixed in the
> > version of gcc supplied with MingW? If someone could post
> to the list
> > an SQL command that throws a GEOS exception then it would
> be good for
> > someone to test this....
>
> select geosnoop('POLYGON((0 0, 1 1, 0 0))');
> --strk;


OK, I've just compiled PostgreSQL 8.0b3/PostGIS 0.9 CVS branch WITHOUT using
LDFLAGS=-lstdc++ under Win32 and here are the results:

Welcome to psql 8.0.0beta3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

Warning: Console codepage (850) differs from windows codepage (1252)
         8-bit characters will not work correctly. See PostgreSQL
         documentation "Installation on Windows" for details.

test=# \d
              List of relations
 Schema |       Name       | Type  |  Owner
--------+------------------+-------+----------
 public | geometry_columns | table | postgres
 public | spatial_ref_sys  | table | postgres
(2 rows)

test=# select geosnoop('POLYGON((0 0, 1 1, 0 0))');
NOTICE:  IllegalArgumentException: Number of points must be 0 or >3
ERROR:  Couldnt convert the postgis geometry to GEOS!
test=#


This is great news as the backend didn't die. It means that it should be
possible to distribute just the extra PostGIS DLL/SQL files as a stand-alone
installer (as done at http://dcmms.sourceforge.net/postgis_installer.php)
without requiring a specially compiled PostgreSQL to go with it.

FWIW this was again under MinGW 3.1.0-1 and MSYS 1.0.10 (gcc 3.2.3).


Kind regards,

Mark.

------------------------
WebBased Ltd
South West Technology Centre
Tamar Science Park
Plymouth
PL6 8BT

T: +44 (0)1752 791021
F: +44 (0)1752 791023
W: http://www.webbased.co.uk


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users