Re: [postgis-users] ST_Contains(a.coordinates::::geometry, b.coordinates::::geometry)

2011-08-09 Thread Sandro Santilli
On Tue, Aug 09, 2011 at 10:28:34PM +0300, Antonio Rodriges wrote: > Thank you, Sandro, > > yes, I clearly understand this, but all my contours are CLOSED and > NONE of them intersects each other. many of them contain each other. > actually, they are like isobars on synoptic map, > > please, see f

Re: [postgis-users] ST_Contains(a.coordinates::::geometry, b.coordinates::::geometry)

2011-08-09 Thread Antonio Rodriges
Thank you, Sandro, yes, I clearly understand this, but all my contours are CLOSED and NONE of them intersects each other. many of them contain each other. actually, they are like isobars on synoptic map, please, see for ex http://1.bp.blogspot.com/_a1AVUIK5Er8/S27QJhQijOI/I88/NUJE11Me6n4/

Re: [postgis-users] ST_Contains(a.coordinates::::geometry, b.coordinates::::geometry)

2011-08-09 Thread Sandro Santilli
On Tue, Aug 09, 2011 at 04:44:48PM +0300, Antonio Rodriges wrote: > Dear all, > > I have the table "contours" which stores geography column > "coordinates" - these are closed polylines, many of them span a half > of a globe. Closed polylines contain each other only if there's NO point in one of t

[postgis-users] ST_Contains(a.coordinates::::geometry, b.coordinates::::geometry)

2011-08-09 Thread Antonio Rodriges
Dear all, I have the table "contours" which stores geography column "coordinates" - these are closed polylines, many of them span a half of a globe. When I perform select a.id, b.id, ST_Contains(a.coordinatesgeometry, b.coordinatesgeometry) AS result from contours a CROSS JOIN contours b

Re: [postgis-users] ERROR: could not find function "isvalidreason" in file "/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"

2011-08-09 Thread Mark Cave-Ayland
On 09/08/11 09:04, ml ml wrote: Hello, i am trying to restore a postgres dump on a freshly installed Debian Squeeze Box. I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source. Postgresql 8.2.20: ./configure --prefix=/usr/local/postgresql-8.2.20 --with-perl --with-openssl --with

Re: [postgis-users] ERROR: could not find function "isvalidreason" in file "/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"

2011-08-09 Thread Sandro Santilli
On Tue, Aug 09, 2011 at 10:04:41AM +0200, ml ml wrote: > I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source. ... > pg_restore: [archiver (db)] Error from TOC entry 43383; 1255 3510237 > FUNCTION st_isvalidreason(geometry) pgsql > pg_restore: [archiver (db)] could not execute quer

[postgis-users] ERROR: could not find function "isvalidreason" in file "/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"

2011-08-09 Thread ml ml
Hello, i am trying to restore a postgres dump on a freshly installed Debian Squeeze Box. I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source. Postgresql 8.2.20: ./configure --prefix=/usr/local/postgresql-8.2.20 --with-perl --with-openssl --with-libxslt --with-libxml Geos: ./conf