[postgis-users] ERROR: Can't find function postgis_gist_sel in file /lib/postgis.dll
"Morin, Marc-André"
Marc-Andre.Morin at drdc-rddc.gc.ca
Wed Mar 26 05:09:12 PST 2003
Here is my Makefile...
Thanks in advance,
Marc-André
# Configuration Directives
#---------------------------------------------------------------
# Set USE_PROJ to 1 for Proj4 reprojection support
#
USE_PROJ=0
PROJ_DIR=/usr/local
#---------------------------------------------------------------
# Set USE_STATS to 1 for new GiST statistics collection support
# Note that this support requires additional columns in
# GEOMETRY_COLUMNS, so see the list archives for info or
# install a fresh database using postgis.sql
#
USE_STATS=1
#---------------------------------------------------------------
subdir=contrib/postgis
#---------------------------------------------------------------
# Default the root of the PostgreSQL source tree
# To use a non-standard location set the PGSQL_SRC environment
# variable to the appropriate location.
#
ifeq (${PGSQL_SRC},)
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
LPATH := $$libdir
else
top_builddir = ${PGSQL_SRC}
include $(top_builddir)/src/Makefile.global
LPATH := ${PWD}
endif
#---------------------------------------------------------------
# Test the version string and set the USE_VERSION macro
# appropriately.
#
ifneq ($(findstring 7.1,$(VERSION)),)
USE_VERSION=71
else
ifneq ($(findstring 7.2,$(VERSION)),)
USE_VERSION=72
else
USE_VERSION=73
endif
endif
#---------------------------------------------------------------
# Regression test temporary database.
#
TEST_DB=geom_regress
#---------------------------------------------------------------
# Shared library parameters.
#
NAME=postgis
SO_MAJOR_VERSION=0
SO_MINOR_VERSION=7
#---------------------------------------------------------------
# override CPPFLAGS := -I$(srcdir) $(CPPFLAGS)
# Altered for Cynwin
ifeq ($(USE_PROJ),1)
override CPPFLAGS := -g -I$(PROJ_DIR)/include -I$(srcdir)
$(CPPFLAGS) -DFRONTEND -DSYSCONFDIR='"$(sysconfdir)"' -DUSE_PROJ
-DUSE_VERSION=$(USE_VERSION)
else
override CPPFLAGS := -g -I$(srcdir) $(CPPFLAGS) -DFRONTEND
-DSYSCONFDIR='"$(sysconfdir)"' -DUSE_VERSION=$(USE_VERSION)
endif
override DLLLIBS := $(BE_DLLLIBS) $(DLLLIBS)
#---------------------------------------------------------------
# Add index selectivity to C flags
#
ifeq ($(USE_STATS),1)
override CPPFLAGS += -DUSE_STATS
endif
#---------------------------------------------------------------
# Select proper GiST support C file
#
ifeq ($(USE_VERSION),71)
GIST_SUPPORT=71
GIST_ESTIMATE=
else
GIST_SUPPORT=72
GIST_ESTIMATE=#postgis_estimate.o
endif
OBJS=postgis_debug.o postgis_ops.o postgis_fn.o postgis_inout.o
postgis_proj.o postgis_chip.o postgis_transform.o
postgis_gist_$(GIST_SUPPORT).o $(GIST_ESTIMATE)
#---------------------------------------------------------------
# Add libraries that libpq depends (or might depend) on into the
# shared library link. (The order in which you list them here doesn't
# matter.)
SHLIB_LINK=$(filter -L%, $(LDFLAGS))
ifeq ($(USE_PROJ),1)
SHLIB_LINK=$(filter -L%, $(LDFLAGS)) -L$(PROJ_DIR)/lib -lproj
else
SHLIB_LINK=$(filter -L%, $(LDFLAGS)) ../../src/backend/libpostgres.a
endif
#---------------------------------------------------------------
# Makefile targets
all: all-lib $(NAME).sql $(NAME).sql $(NAME)_undef.sql loaderdumper
loaderdumper:
$(MAKE) -C loader
# Shared library stuff
include $(top_srcdir)/src/Makefile.shlib
$(NAME).sql: $(NAME)_sql_common.sql.in $(NAME)_sql_$(USE_VERSION)_end.sql.in
$(NAME)_sql_$(USE_VERSION)_start.sql.in
cat $(NAME)_sql_$(USE_VERSION)_start.sql.in
$(NAME)_sql_common.sql.in $(NAME)_sql_$(USE_VERSION)_end.sql.in | sed -e
's:@MODULE_FILENAME@:$(LPATH)/$(shlib):g;s:@POSTGIS_VERSION@:$(SO_MAJOR_VERS
ION).$(SO_MINOR_VERSION):g' > $@
$(NAME)_undef.sql: $(NAME).sql create_undef.pl
perl create_undef.pl $< $(USE_VERSION) > $@
install: all installdirs install-lib
$(INSTALL_DATA) $(srcdir)/README.$(NAME) $(docdir)/contrib
$(INSTALL_DATA) $(NAME).sql $(datadir)/contrib
$(INSTALL_DATA) $(NAME)_undef.sql $(datadir)/contrib
$(INSTALL_DATA) spatial_ref_sys.sql $(datadir)/contrib
$(INSTALL_DATA) README.postgis $(datadir)/contrib
$(MAKE) -C loader install
installdirs:
$(mkinstalldirs) $(docdir)/contrib $(datadir)/contrib $(libdir)
uninstall: uninstall-lib
@rm -f $(docdir)/contrib/README.$(NAME)
$(datadir)/contrib/$(NAME).sql
clean distclean maintainer-clean: clean-lib
@rm -f $(OBJS) $(NAME).sql $(NAME)_undef.sql
$(MAKE) -C loader clean
test: all
csh regress/regress.csh $(TEST_DB)
-----Message d'origine-----
De : Paul Ramsey [mailto:pramsey at refractions.net]
Envoyé : Tuesday, March 25, 2003 6:53 PM
À : PostGIS Users Discussion
Objet : Re: [postgis-users] ERROR: Can't find function postgis_gist_sel
in file /lib/postgis .dll
It is possible that in hacking up your Makefile to get other things to
work you ended up commenting out an important object file. What does
your Makefile look like?
P.
Morin, Marc-André wrote:
> I'm trying to set up the myGISdb database with PostGIS and I get the
> following errors:
>
> $ psql -U postgres -d myGISdb -f postgis.sql
> ...
> NOTICE: Argument type "geometry" is only a shell
> psql:postgis.sql:125: NOTICE: Argument type "geometry" is
> only a shell
> CREATE FUNCTION
> CREATE TYPE
> ERROR: Can't find function postgis_gist_sel in file /lib/postgis.dll
> psql:postgis.sql:142: ERROR: Can't find function postgis_gist_sel in file
> /lib/postgis.dll
> ERROR: current transaction is aborted, queries ignored until end of
> transaction
> block
> ...
>
> Does anybody could help me?
>
> Thanks in advance,
>
> Marc-André
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
--
__
/
| Paul Ramsey
| Refractions Research
| Email: pramsey at refractions.net
| Phone: (250) 885-0632
\_
_______________________________________________
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