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.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
