[postgis-users] problem loading lwpostgis.sql - libgeos

[Paul Ramsey]

Can you re-build GEOS and run "make test"? The problem seems to be a
symbol that GEOS can't find rather than one lwpostgis can't find.

P

On Fri, Apr 18, 2008 at 3:09 AM, Ronald Woita <Ronald.Woita at rostock.de> wrote:
> Hi list,
>
>  I have a problem loading the lwpostgis.sql into a database.
>  (plpgsql is already loaded)
>
>  this is the message from Postgres-Serverlog :
>
>  -->
>  NOTICE:  type "histogram2d" is not yet defined
>  DETAIL:  Creating a shell type definition.
>  ERROR:  could not load library "/usr/local/pgsql/lib/liblwgeom.so":
>  /usr/local/lib/libgeos-3.0.0.so: undefined symbol:
>  _ZTVN10__cxxabiv120__si_class_type_infoE
>  STATEMENT:  CREATE OR REPLACE FUNCTION histogram2d_in(cstring)
>                 RETURNS histogram2d
>                 AS '/usr/local/pgsql/lib/liblwgeom', 'lwhistogram2d_in'
>                 LANGUAGE 'C' IMMUTABLE STRICT;
>  ERROR:  current transaction is aborted, commands ignored until end of
>  transaction block
>  <--
>  (for complete log see attachement)
>
>  ldd liblwgeom.so provides this :
>         linux-gate.so.1 =>  (0xffffe000)
>         libgeos_c.so.1 => /usr/local/lib/libgeos_c.so.1 (0xb7e7a000)
>         libproj.so.0 => /usr/local/lib/libproj.so.0 (0xb7e48000)
>         libc.so.6 => /lib/libc.so.6 (0xb7d27000)
>         libgeos-3.0.0.so => /usr/local/lib/libgeos-3.0.0.so
>  (0xb7aac000)
>         libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xb7aa0000)
>         libm.so.6 => /lib/libm.so.6 (0xb7a7b000)
>         /lib/ld-linux.so.2 (0x80000000)
>
>  I checked the libraries and did'nt found any errors.
>  the necessary path variables /usr/local/pgsql/lib and /usr/local/lib
>  are correctly listed  in /etc/ld.so.conf
>
>  any hints welcome !
>
>  The System Enviroment is
>  PostgeSQL 8.3.1
>  PostGIS 1.3.3
>  GEOS-3.0.0
>  on SLES 10SP1
>
>
>  best regards
>  Ronald
>
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>