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

Paul Ramsey pramsey at refractions.net
Wed May 8 16:23:27 PDT 2002


Chris,
In the 7.1 indexes, the C function ggeometry_consistent returns a bool,
and the SQL binding also defines bool as the return.  In the 7.2
indexes, the C function returns a Datum, though the SQL returns a bool.
Could it be that the type checking is stronger in solaris? Test the 7.2
bindings on ox and see if it works there.
Paul

Jonathan Lowe wrote:
> 
> 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
> --------------------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list