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

[Mark Cave-Ayland]

> -----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