[postgis-users] Postgre 8.3.5 & PostGIS SVN 2008-11-13 Updates

[Balkan Uraz]

Dear All;

We have been informed that Postgre 8.3.5 Update is critical for especially
GIST indexes. Therefore we decided to upgrade both Postgre & PostGIS.

We have backed up our system:

   - Postgre 8.3.3
   - PostGIS 2008-10-08 SVN
   - PROJ.4 SVN
   - GEOS 3.0.0

We have then, upgraded to 8.3.5 Update for Postgre and 2008-11-13 SVN for
PostGIS. However, we were not successful to restore our data back in some
tables. The error was:


ERROR:  geometry requires more points

  HINT:  "...000100000003000000E71A66683C954F40018926" <-- parse error at
position 74 within geometry

  CONTEXT:  COPY dunyayerlesimalanlari, line 12024, column the_geom:
"0106000020E61000000100000001030000000100000003000000E71A66683C954F4001892650C4184B40BF45274BAD934F40..."

  STATEMENT:  COPY dunyayerlesimalanlari (gid, name, featype, the_geom) FROM
stdin;



We couldn't find a way, therefore we reverted all our system back to 8.3.3
and PostGIS 2008-10-08 SVN .



Do you have any ideas on the error? How could we resolve that error?



Also, not specific for this error; is there any predefined procedures for
updating the Postgre & PostGIS instances?



Thanks for your help,



Regards,



Balkan Uraz.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20081115/6777a507/attachment.html>