[postgis-users] ERROR: Can't find function postgis_gist_sel in file /lib/postgis.dll

["Morin, Marc-André"]

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