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

[Chris Hodgson]

Is it possible that it is using an old library file, from when you perhaps had postgres
7.1 installed in the same directory? I would suggest this as a possibility because the
ggeometry_consistent function is the first function defined in postgis.sql which changed
in the library from 7.1 to 7.2. Check the date on the library file, and ensure that it is
being copied correctly, and referenced correctly by the sql file.

We have tested it on Solaris 6 on our SPARC  box, and it compiles, installs, and functions
correctly, so it doesn't seem to be just a "Solaris bug".

Chris

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