[postgis-users] undefined symbol: DirectFunctionCall2 ?

[Paul Ramsey]

For a hard upgrade, do the following steps:

Create a new database
Load PostGIS 1.5 into that blank database
Load your dump file into that PostGIS 1.5 database
Watch a lot of errors go by

I think it's possible you've created a new database in PgSQL 9.1 but
still linked all your functions to the old PostGIS library, which is
not what you're trying to acheive.

Paul

On Tue, Sep 27, 2011 at 1:09 PM, Greg Allensworth <gregor at greeninfo.org> wrote:
> When trying to install PostGIS into a new database, or to upgrade it within
> an existing database, I am getting this error:
>
> ERROR:  could not load library "/usr/lib/liblwgeom.so.1.3":
> /usr/lib/liblwgeom.so.1.3: undefined symbol: DirectFunctionCall2
>
> Any ideas on what that error means? Google wasn't any help.
>
> A little background: We had PostGIS 1.2 and needed 1.5, which meant
> upgrading PostgreSQL from 8.2 to 9.1 and then doing a PostGIS hard upgrade.
>
> The large majority of the process works out just fine, so I can at least
> hobble along with the PostGIS functions I need. But these functions
> specifically (see below), generate that error.
>
>
>
> CREATE FUNCTION asgml(geometry, integer, integer) RETURNS text
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_asGML'
>    LANGUAGE c IMMUTABLE STRICT;
>
>
> CREATE FUNCTION asukml(geometry, integer, integer) RETURNS text
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_asKML'
>    LANGUAGE c IMMUTABLE STRICT;
>
> CREATE FUNCTION st_asukml(geometry, integer, integer) RETURNS text
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_asKML'
>    LANGUAGE c IMMUTABLE STRICT;
>
>
>
>
> CREATE FUNCTION box2d_contain(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_contain'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_contained(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_contained'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_intersects(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_intersects'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_left(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_left'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_overlap(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_overlap'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_overleft(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_overleft'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_overright(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_overright'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_right(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_right'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION box2d_same(box2d, box2d) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'BOX2D_same'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION cache_bbox() RETURNS "trigger"
>    AS '/usr/lib/liblwgeom.so.1.3', 'cache_bbox'
>    LANGUAGE c;
> CREATE FUNCTION collect_garray(geometry[]) RETURNS geometry
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_collect_garray'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION collector(geometry, geometry) RETURNS geometry
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_collect'
>    LANGUAGE c IMMUTABLE;
> CREATE FUNCTION geom_accum(geometry[], geometry) RETURNS geometry[]
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_accum'
>    LANGUAGE c IMMUTABLE;
> CREATE FUNCTION geosnoop(geometry) RETURNS geometry
>    AS '/usr/lib/liblwgeom.so.1.3', 'GEOSnoop'
>    LANGUAGE c STRICT;
> CREATE FUNCTION st_addbbox(geometry) RETURNS geometry
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_addBBOX'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION st_dropbbox(geometry) RETURNS geometry
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_dropBBOX'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION st_hasbbox(geometry) RETURNS boolean
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_hasBBOX'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION st_max_distance(geometry, geometry) RETURNS double precision
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_maxdistance2d_linestring'
>    LANGUAGE c IMMUTABLE STRICT;
> CREATE FUNCTION st_noop(geometry) RETURNS geometry
>    AS '/usr/lib/liblwgeom.so.1.3', 'LWGEOM_noop'
>    LANGUAGE c STRICT;
>
>
>
> --
> Greg Allensworth, Web GIS Developer
> BS  A+  Network+  Security+  Linux+  Server+  ZCE-PHP
> GreenInfo Network - Information and Mapping in the Public Interest
> 564 Market Street, Suite 510  San Francisco CA 94104
> PH: 415-979-0343 x302  FX: 415-979-0371    email: gregor at greeninfo.org
> Web: www.GreenInfo.org     www.MapsPortal.org
>
> Subscribe to MapLines, our e-newsletter, at www.GreenInfo.org
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>