Has anybody encountered a problem like this when doing pg_dump/pg_restore 
between two different postgis databases?

pg_restore: [archiver (db)] could not execute query: ERROR:  could not find 
function "LWGEOM_dwithin" in file "/usr/lib/postgresql/8.3/lib/liblwgeom.so"
    Command was: CREATE FUNCTION _st_dwithin(geometry, geometry, double 
precision) RETURNS boolean
    AS '$libdir/liblwgeom', 'LWGEOM_dwithi..

I am copying from a Windows instance to a slightly newer ubuntu instance:

 PostgreSQL 8.3.5, compiled by Visual C++ build 1400
(1 row)

 PostgreSQL 8.3.7 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 
4.3.3-5ubuntu4) 4.3.3
(1 row)

Did anything change with regard to _st_dwithin before those versions?  If so, 
does anybody have advice on working around compatibility issues?


_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to