Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-22 Thread Sandro Santilli
On Fri, Nov 22, 2013 at 11:28:45AM +0100, Huub Fleuren wrote: Ha Sandro Yes, you have to run make install, and run it _before_ loading the scripts upgrader. oke well, please update the manual to discribe upgrade (SOFT and HARD) a little more in the PostGIS manual. Could you please file

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-22 Thread Huub Fleuren
Could you please file a ticket on http://trac.osgeo.org/postgis/ ? i 'll try that, and the patch to the ticket The upgrade scripts are created under different subdirectories in the build tree. Of course you won't see them in the system directories until you make install. $ make install

[postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Huub Fleuren
Hello, I found that there is a difference in result between using A B operator or one of the geo functions like st_intersects(A,B) or st_overlaps(A,B) While the st_intersects or st_overlaps functions returns query results without errors the operator version SOMETIMES results in errors

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Huub Fleuren
On 11/21/2013 5:23 PM, Sandro Santilli wrote: SELECT postgis_full_version() POSTGIS=1.5.2 GEOS=3.2.2-CAPI-1.6.2 PROJ=Rel. 4.7.1, 23 September 2009 LIBXML=2.7.6 USE_STATS -- *Geodan* Buitenhaven 27-A 5211 TP 's-Hertogenbosch (NL) T +31 (0)73 - 692 5151 E huub.fleu...@geodan.nl

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread RĂ©mi Cura
Hey, It's difficult to help if you don't provide an example of non-working-as-intended-query. The 2 queries above can't run without 'soils.vw_zones' table, so I can't reproduce your bug. Can you try to update all your table with UPDATE soils.vw_zones SET geometry = ST_SetSRID(geom, XXX); Also

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Huub Fleuren
On 11/21/2013 6:37 PM, Sandro Santilli wrote: On Thu, Nov 21, 2013 at 06:01:47PM +0100, Huub Fleuren wrote: i upgraded to 1.5.8 without succes, where is 1.5.9? i guess 1.5.9will come soon By the way: i did NOT use make install, because it is an upgrade no? Should i run make install? The

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Sandro Santilli
On Thu, Nov 21, 2013 at 04:27:12PM +0100, Huub Fleuren wrote: While the st_intersects or st_overlaps functions returns query results without errors the operator version SOMETIMES results in errors over the SRID: ERROR: Operation on two geometrys with different SRID's. [...] All of the

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Sandro Santilli
On Thu, Nov 21, 2013 at 05:25:45PM +0100, Huub Fleuren wrote: On 11/21/2013 5:23 PM, Sandro Santilli wrote: SELECT postgis_full_version() POSTGIS=1.5.2 GEOS=3.2.2-CAPI-1.6.2 PROJ=Rel. 4.7.1, 23 September 2009 LIBXML=2.7.6 USE_STATS Memory corrupting bugs have been fixed by version later than

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Huub Fleuren
i upgraded to 1.5.8 without succes, where is 1.5.9? I did the folowing wget http://download.osgeo.org/postgis/source/postgis-1.5.8.tar.gz http://download.osgeo.org/postgis/source/postgis-1.5.8.tar.gz (where is 1.5.9?) tar xvzf postgis-2.1.1.tar.gz cd postgis-2.1.1 ./configure make

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Sandro Santilli
On Thu, Nov 21, 2013 at 06:01:47PM +0100, Huub Fleuren wrote: i upgraded to 1.5.8 without succes, where is 1.5.9? Now this is a good question ! Paul ? The NEWS file considers 1.5.9 released on November 15, and has entries for 1.5.10 already, but trac thinks there are still 2 open tickets for

Re: [postgis-users] operator return errors where st_overlaps or st_intersects does not

2013-11-21 Thread Sandro Santilli
On Thu, Nov 21, 2013 at 07:11:34PM +0100, Huub Fleuren wrote: On 11/21/2013 6:37 PM, Sandro Santilli wrote: On Thu, Nov 21, 2013 at 06:01:47PM +0100, Huub Fleuren wrote: i upgraded to 1.5.8 without succes, where is 1.5.9? i guess 1.5.9will come soon By the way: i did NOT use make install,