[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 10:01:46 PST 2003 

Sorry Paul...

That it the error that I get even if I assign a value to GIST_ESTIMATE...

...
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
...

Excuse my confusion!

Marc-André




-----Message d'origine-----
De : Morin, Marc-André 
Envoyé : Wednesday, March 26, 2003 12:55 PM
À : 'PostGIS Users Discussion'
Objet : RE: [postgis-users] ERROR: Can't find function postgis_gist_sel
in file /lib/postgis.dll


I saw that mistake but even if I assign postgis_estimate.o to GIST_ESTIMATE,

#---------------------------------------------------------------
# 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

I get the same error:

$ psql -U postgres -d myGISdb -f postgis.sql
BEGIN
        message
------------------------
 PL/PgSQL is installed.
(1 row)

NOTICE:  ProcedureCreate: type histogram2d is not yet defined
psql:postgis.sql:18: NOTICE:  ProcedureCreate: type histogram2d is not yet
defin
ed
ERROR:  stat failed on file '$libdir/postgis.dll': No such file or directory
psql:postgis.sql:18: ERROR:  stat failed on file '$libdir/postgis.dll': No
such
file or directory
ERROR:  current transaction is aborted, queries ignored until end of
transaction
 block

...

Help! ;-)

Marc-André


-----Message d'origine-----
De : Paul Ramsey [mailto:pramsey at refractions.net]
Envoyé : Wednesday, March 26, 2003 10:45 AM
À : PostGIS Users Discussion
Objet : Re: [postgis-users] ERROR: Can't find function postgis_gist_sel
in file /lib/postgis.dll


There it is. You have postgis_estimate.o commented out, and that is the  
file where the gis_sel function lives.
P.

On Wednesday, March 26, 2003, at 05:09 AM, Morin, Marc-André wrote:

> 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
>
>
> _______________________________________________
> 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