[postgis-users] Error running postgis.sql and libpostgis.so.0.7

[Jonathan Lowe]

Hello,

An error is surfacing at the tail end of a PostGIS installation on a
Solaris 2.7 platform with PostgreSQL 7.2.1 and postgis 0.7.0.

The following commands were successful:
      "make" (with the 72 switch set to "1")
      "make install" (with a perl script fix of some DOS carriage return
problems)
      "createlang plpgsql <yourdatabase>"

However, the command "psql -f postgis.sql -d <yourdatabase>" results in the
following error:

(...long list of various successful transactions...)
BEGIN
psql:postgis.sql:764: ERROR:  Can't find function ggeometry_consistent in
file /local3/pgsql/lib/contrib/libpostgis.so.0.7
BEGIN TRANSACTION;
(...remaining function creation statements within this BEGIN work block
aborted...)

The path (/local3/pgsql/lib/contrib) and library file are correct and
exist.

The statement in the postgis.sql file raising the error is the following:

-------- 7.2 GiST support functions
create function ggeometry_consistent(opaque,GEOMETRY,int4) returns bool
as '/local3/pgsql/lib/contrib/libpostgis.so.0.7'   language 'C';

Commenting out these lines and running the postgis.sql file again results
in a similar error for the next "create function" statement, which also
relies on the libpostgis.so.0.7 file.

Other archived discussions refer to this lib file, but not in the context
of running postgis.sql.

Any suggestions?

Regards,

Jonathan W. Lowe (jonathan at us.ibm.com)
Senior IT Specialist, IBM Data Management
--------------------------------------------------------------------------------------