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