[postgis] (unknown)

Dave Blasby dblasby at refractions.net
Fri Dec 28 12:51:29 PST 2001

comp_sjc wrote:

> psql:postgis.sql:212: NOTICE:  ProcedureCreate: type 'box3d' is not yet defined
> ERROR:  Can't find function box3d_in in file /usr/lib/pgsql/plpgsql.so
> psql:postgis.sql:212: ERROR:  Can't find function box3d_in in file /usr/lib/pgsql/plpgsql.so
> NOTICE:  current transaction is aborted, queries ignored until end of transaction block

For some reason, its looking for the postgis functions in "/usr/lib/pgsql/plpgsql.so".  This is the library for the "built-in"
postgresql scripting language, NOT the postgis library.

Try looking at the install docs at "http://postgis.refractions.net"

If that didnt help:

How did you install postgis?  What version are you using?

The makefile should have changed all the "@MODULE_FILENAME@" in postgis.sql.in to wherever it installs the postgis library (usually
something like "/usr/lib/pgsql/contrib/libpostgis.so", I think).  The result of this substitution is the file "postgis.sql".  For some
reason your system has (incorrectly) replaced "@MODULE_FILENAME@" with "/usr/lib/pgsql/plpgsql.so".  I dont know why it would do that.
Did you make any custom modifications?

Simple fix:
1. Find where your "libpostgis.so.0.6"  got created.  It should be in your postgresql "contrib/postgis" directory.
2. In the postgis directory, try running this:

    sed -e 's:@MODULE_FILENAME@:<path to your libpostgis.so.0.6>:g;s:@POSTGIS_VERSION@:0.6:g' < postgis.sql.in >postgis.sql

On my machine this looks like:

 sed -e 's:@MODULE_FILENAME@:/data1/Refractions/Projects/PostGIS/work_dave/postgis/libpostgis.so.0.6:g;s:@POSTGIS_VERSION@:0.6:g' <
postgis.sql.in >postgis.sql


------------------------ Yahoo! Groups Sponsor ---------------------~-->
Send FREE Holiday eCards from Yahoo! Greetings.

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com


Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 

More information about the postgis-users mailing list