<HTML dir=ltr><HEAD><TITLE>Re: [postgis-users] I'm missing something</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16640" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText51614 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Bob,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>You make it sound like you have to perform major surgery.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Which OS are you running?</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2> It should be a fairly straightforward upgrade</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>1) Replacing the lib/liblwgeom.dll or .so file with the good one and share\contrib\postgis\lwpostgis_upgrade.sql and share\contrib\lwpostgis.sql files with the new ones</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>2) then running the share\contrib\postgislwpostgis_upgrade.sql against your database</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>If you are installing with an install package (most do step 1 for you) so you just need to do step 2.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>The important thing is (YOU DO NOT NEED TO RELOAD YOUR DB) for this simple change and should take about 5 - 10 minutes. This change doesn't affect how data is stored, adds a few functions, and fixes the external c functions of existing ones)</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Hope that helps,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regina</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> postgis-users-bounces@postgis.refractions.net on behalf of Bob Pawley<BR><B>Sent:</B> Tue 5/20/2008 6:29 PM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] I'm missing something<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>I was hoping not to have to do that - but.<BR><BR>Thanks everyone for your help.<BR><BR>Bob<BR><BR>----- Original Message -----<BR>From: "Mark Cave-Ayland" <mark.cave-ayland@siriusit.co.uk><BR>To: "PostGIS Users Discussion" <postgis-users@postgis.refractions.net><BR>Sent: Tuesday, May 20, 2008 3:23 PM<BR>Subject: Re: [postgis-users] I'm missing something<BR><BR><BR>> Bob Pawley wrote:<BR>>> This is the version recently downloaded with Postgresql 8.3.<BR>>><BR>>> POSTGIS="1.3.2" GEOS="3.0.0rc4-CAPI-1.3.3"PROJ='Rel.4.5.0, 22 Oct 2006"<BR>>> USE<BR>>> STATS<BR>><BR>><BR>> Hi Bob,<BR>><BR>> Sounds like you are suffering from one of the many PostgreSQL 8.3 bugs in<BR>> 1.3.2. Upgrade to 1.3.3 and the problem should go away.<BR>><BR>><BR>> HTH,<BR>><BR>> Mark.<BR>><BR>> --<BR>> Mark Cave-Ayland<BR>> Sirius Corporation - The Open Source Experts<BR>> <A href="http://www.siriusit.co.uk/">http://www.siriusit.co.uk</A><BR>> T: +44 870 608 0063<BR>><BR>><BR>> _______________________________________________<BR>> postgis-users mailing list<BR>> postgis-users@postgis.refractions.net<BR>> <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR><BR>_______________________________________________<BR>postgis-users mailing list<BR>postgis-users@postgis.refractions.net<BR><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></FONT></P></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>
<P><hr size=1></P>
<P><STRONG><font size="2" color="339900"> Help make the earth a greener place. If at all possible resist printing this email and join us in saving paper. </p> <p> </font></STRONG></P>