<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1491" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hi </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I tried to compil PostGIS RC3 on Windows XP with
Geos 2.1.1 and Proj 4.4.9</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>and PG 8.0.0 (final version)...</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I tried to to few test (see this
file...)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>SCHEMA</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://postgresqlwin32.free.fr/Tutorial_PostGIS/pg800/beta5/1_schema.sql">http://postgresqlwin32.free.fr/Tutorial_PostGIS/pg800/beta5/1_schema.sql</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>QUERIES</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><A
href="http://postgresqlwin32.free.fr/Tutorial_PostGIS/pg800/beta5/2_query.sql">http://postgresqlwin32.free.fr/Tutorial_PostGIS/pg800/beta5/2_query.sql</A></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>For teh following query:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><!--StartFragment --> <PRE>select b.data from buildings b,
(select geomunion(the_geom) from pedestrians) gp
where
not intersects(gp.geomunion,b.the_geom);</PRE><PRE> </PRE><PRE>My PG server crashed and terminated abnormally</PRE><PRE>I suppoded perhaps I should compil PG with LDFLAGS=-lstdc++ (???)</PRE><PRE>I don't know since my tests workes for RC1 and RC2???</PRE><PRE> </PRE><PRE>What do U think??</PRE><PRE> </PRE><PRE>Thanks for your answers</PRE></DIV>
<DIV><FONT face=Arial
size=2>----------------------------------------------------------------<BR>TECHER
Jean David<BR>Responsable Informatique 01MAP<BR>e-mail: <A
href="mailto:davidtecher@yahoo.fr">davidtecher@yahoo.fr</A><BR>Bureau: 04 67 45
60 27<BR>Portable: 06 85 37 36 75<BR>site perso : <A
href="http://techer.pascal.free.fr/postgis/">http://techer.pascal.free.fr/postgis/</A><BR>site
pro: <A
href="http://www.01map.com/download/">http://www.01map.com/download/</A><BR>K-S:"The
greatest trick the devil pulled off was convincing people he didn't
exist"<BR>------------------------------------------------------------</FONT></DIV></BODY></HTML>