function postgis_lib_version() does not exist

[hansgeorg.schwibbe]

What steps will reproduce the problem?

1. ./configure
2. make
3. make check

What is the expected output? What do you see instead? make check make -C regress test make[1]: Entering directory `/home/delphi/Desktop/postgis-1.3.2/regress' Creating spatial db postgis_reg ERROR: function postgis_lib_version() does not exist LINE 1: select postgis_lib_version()

HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Something went wrong (no postgis installed in postgis_reg). For details, check /tmp/pgis_reg_6009/regress_log

make[1]: * [test] Fehler 1 make[1]: Leaving directory `/home/delphi/Desktop/postgis-1.3.2/regress' make: * [check] Fehler 2

What version of the product are you using? On what operating system? PostGIS 1.3.2 with PostgreSQL 8.3.1 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 4.1.2 20061115 (prerelease) (Debian 4.1.1-21)

Please provide any additional information below. ./configure gives the following output: checking for gcc… gcc checking for C compiler default output file name… a.out checking whether the C compiler works… yes checking whether we are cross compiling… no checking for suffix of executables… checking for suffix of object files… o checking whether we are using the GNU C compiler… yes checking whether gcc accepts -g… yes checking for gcc option to accept ISO C89… none needed checking for g++… g++ checking whether we are using the GNU C++ compiler… yes checking whether g++ accepts -g… yes checking whether ln -s works… yes checking for iconv_open in -liconv… no checking for libiconv_open in -liconv… no checking for iconv_open in -lc… yes checking how to run the C preprocessor… gcc -E checking for grep that handles long lines and -e… /bin/grep checking for egrep… /bin/grep -E checking for ANSI C header files… yes checking for sys/types.h… yes checking for sys/stat.h… yes checking for stdlib.h… yes checking for string.h… yes checking for memory.h… yes checking for strings.h… yes checking for inttypes.h… yes checking for stdint.h… yes checking for unistd.h… yes checking iconv.h usability… yes checking iconv.h presence… yes checking for iconv.h… yes checking build system type… i686-pc-linux-gnu checking host system type… i686-pc-linux-gnu checking for pg_config… /usr/local/bin/pg_config checking for geos-config… /usr/local/bin/geos-config checking for proj… /usr/local/bin/proj checking for flex… /usr/bin/flex checking for dllwrap… no checking for dlltool… no checking for bison… bison -y checking for perl… /usr/bin/perl checking for xsltproc… /usr/bin/xsltproc checking for pdfxmltex… no checking for db2pdf… no checking for jw… no checking which template to use… linux configure: creating ./config.status config.status: creating Makefile.config config.status: WARNING: Makefile.config.in seems to ignore the —datarootdir setting config.status: creating config.h

SUMMARY ———————————————————————————-

HOST_OS: linux-gnu

PGSQL: /usr/local/bin/pg_config

GEOS: /usr/local/bin/geos-config (with C-API)

(ldflags: -L/usr/local/lib)

PROJ: prefix=/usr/local libdir=/usr/local/lib

ICONV: 1

PORTNAME: linux

PREFIX: /usr/local/pgsql

EPREFIX: ${prefix}

DOC: /usr/local/pgsql/doc/contrib

DATA: ${datarootdir}

MAN: ${datarootdir}/man BIN: /usr/local/pgsql/bin EXT: /usr/local/pgsql/lib (\$$libdir)

———————————————————————————-

[mcayland]

Hi,

This is not a PostGIS bug - you'll need to check the regression file /tmp/pgis_reg_6009/regress_log to determine what has happened, as the above error message usually indicates the loading the shared library has failed. Typically this is caused by not changing ld.so.conf to include /usr/local/lib so that PostGIS can find GEOS and/or PROJ.

BTW PostGIS 1.3.2 is broken under PostgreSQL 8.3 - you must upgrade to the latest 1.3.3.

HTH,

Mark.

[hansgeorg.schwibbe]

I switched to the lates version 1.3.3, but the problem still exists. Here are the first lines of the regress_log, I hope it helps: BEGIN psql:lwpostgis.sql:44: NOTICE: type 'histogram2d' is not yet defined DETAIL: Creating a shell type definition. psql:lwpostgis.sql:44: ERROR: could not access file '$libdir/liblwgeom': No such file or directory psql:lwpostgis.sql:50: ERROR: current transaction is aborted, commands ignored until end of transaction block