Thread: Visualize GiST Index
I have been trying to install the Gevel module but am getting an error when running make on the gevel files download. The error is: /contrib/contrib-global.mk: No such file or directory. I have also tried USE_PGXS=1 make, but get the same result. I am unable to find contrib-global.mk. I have postgresql 8.4.4 on ubuntu 9.10. If anybody has any pointers on how to install the gevel module I'd appreciate hearing them. Thanks Andrew Hunter PEng RPSurv PhD Assistant Professor Department of Geomatics Engineering Schulich School of Engineering University of Calgary T: +403.220.7377 F: +403.284.1980 E: ahunter (at) ucalgary (dot) ca ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Andrew Hunter <ahunter@ucalgary.ca> writes: > I have been trying to install the Gevel module but am getting an error when running make on the gevel files download. > The error is: > /contrib/contrib-global.mk: No such file or directory. > I have also tried USE_PGXS=1 make, but get the same result. I am unable to find contrib-global.mk. Could we see the output of "pg_config"? (If you don't have pg_config installed, you're probably missing postgresql-devel or whatever the equivalent subpackage is on Ubuntu.) regards, tom lane
On 2010-09-22, at 9:56 PM, Tom Lane wrote: > Andrew Hunter <ahunter@ucalgary.ca> writes: >> I have been trying to install the Gevel module but am getting an error when running make on the gevel files download. >> The error is: > >> /contrib/contrib-global.mk: No such file or directory. > >> I have also tried USE_PGXS=1 make, but get the same result. I am unable to find contrib-global.mk. > > Could we see the output of "pg_config"? > > (If you don't have pg_config installed, you're probably missing > postgresql-devel or whatever the equivalent subpackage is on Ubuntu.) > > regards, tom lane > > Hi Tom, Here is the output from pg_config andrew@andrew-server:~$ pg_config BINDIR = /usr/lib/postgresql/8.4/bin DOCDIR = /usr/share/doc/postgresql HTMLDIR = /usr/share/doc/postgresql INCLUDEDIR = /usr/include/postgresql PKGINCLUDEDIR = /usr/include/postgresql INCLUDEDIR-SERVER = /usr/include/postgresql/8.4/server LIBDIR = /usr/lib PKGLIBDIR = /usr/lib/postgresql/8.4/lib LOCALEDIR = /usr/share/locale MANDIR = /usr/share/postgresql/8.4/man SHAREDIR = /usr/share/postgresql/8.4 SYSCONFDIR = /etc/postgresql-common PGXS = /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk CONFIGURE = '--build=i486-linux-gnu' '--prefix=/usr' '--includedir=/usr/include' '--mandir=/usr/share/man' '--infodir=/usr/share/info''--sysconfdir=/etc' '--localstatedir=/var' '--libexecdir=/usr/lib/postgresql-8.4' '--disable-maintainer-mode''--disable-dependency-tracking' '--disable-silent-rules' '--srcdir=.' '--mandir=/usr/share/postgresql/8.4/man''--with-docdir=/usr/share/doc/postgresql-doc-8.4' '--sysconfdir=/etc/postgresql-common''--datadir=/usr/share/postgresql/8.4' '--bindir=/usr/lib/postgresql/8.4/bin' '--includedir=/usr/include/postgresql/''--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety' '--enable-debug''--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-krb5' '--with-gssapi' '--with-openssl''--with-libxml' '--with-libxslt' '--with-ldap' '--with-ossp-uuid' '--with-gnu-ld' '--with-tclconfig=/usr/lib/tcl8.5''--with-tkconfig=/usr/lib/tk8.5' '--with-includes=/usr/include/tcl8.5' '--with-system-tzdata=/usr/share/zoneinfo''--with-pgport=5432' 'CFLAGS=-g -O2 -g -Wall -O2 -fPIC' 'LDFLAGS=-Wl,-Bsymbolic-functions-Wl,--as-needed' 'build_alias=i486-linux-gnu' 'CPPFLAGS=' CC = gcc CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/tcl8.5 CFLAGS = -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels-fno-strict-aliasing -fwrapv -g CFLAGS_SL = -fpic LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed LDFLAGS_SL = LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm VERSION = PostgreSQL 8.4.4 Regards Andrew Hunter PEng RPSurv PhD Assistant Professor Department of Geomatics Engineering Schulich School of Engineering University of Calgary T: +403.220.7377 F: +403.284.1980 E: ahunter (at) ucalgary (dot) ca ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Andrew Hunter <ahunter@ucalgary.ca> writes: > On 2010-09-22, at 9:56 PM, Tom Lane wrote: >> Andrew Hunter <ahunter@ucalgary.ca> writes: >>> I have been trying to install the Gevel module but am getting an error when running make on the gevel files download. >>> The error is: >>> /contrib/contrib-global.mk: No such file or directory. >>> I have also tried USE_PGXS=1 make, but get the same result. I am unable to find contrib-global.mk. >> Could we see the output of "pg_config"? > PGXS = /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk Hm. If that file is in fact present, I'd have expected "make USE_PGXS=1" to work. The error you cite looks like what would happen without USE_PGXS --- are you sure you get the exact same error both ways? If you're still baffled, it might help to show Gevel's Makefile. It's possible it isn't invoking pgxs correctly. regards, tom lane
On 2010-09-23, at 10:27 AM, Tom Lane wrote:
Andrew Hunter <ahunter@ucalgary.ca> writes:On 2010-09-22, at 9:56 PM, Tom Lane wrote:Andrew Hunter <ahunter@ucalgary.ca> writes:I have been trying to install the Gevel module but am getting an error when running make on the gevel files download.The error is:/contrib/contrib-global.mk: No such file or directory.I have also tried USE_PGXS=1 make, but get the same result. I am unable to find contrib-global.mk.Could we see the output of "pg_config"?PGXS = /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk
Hm. If that file is in fact present, I'd have expected "make USE_PGXS=1"
to work. The error you cite looks like what would happen without
USE_PGXS --- are you sure you get the exact same error both ways?
If you're still baffled, it might help to show Gevel's Makefile.
It's possible it isn't invoking pgxs correctly.
regards, tom lane
Yes, I got the same result with USE_PGXS=1. This is my first attempt at compiling a module for Postgresql, so it could well be something very simple that I am missing...
Here is the content of the gevel Makefile
subdir = contrib/gevel
top_builddir = ../..
include $(top_builddir)/src/Makefile.global
MODULES = gevel
DATA_built = gevel.sql
DOCS = README.gevel
REGRESS = gevel
include $(top_srcdir)/contrib/contrib-global.mk
I have tried running this from the gevel directory under /usr/share/postgresql/8.4/contrib
Thanks for your assistance.
Regards
Andrew
Andrew Hunter PEng RPSurv PhD
Assistant Professor
Department of Geomatics Engineering
Schulich School of Engineering
University of Calgary
T: +403.220.7377
F: +403.284.1980
E: ahunter (at) ucalgary (dot) ca
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Andrew Hunter <ahunter@ucalgary.ca> writes: > Here is the content of the gevel Makefile > subdir = contrib/gevel > top_builddir = ../.. > include $(top_builddir)/src/Makefile.global > MODULES = gevel > DATA_built = gevel.sql > DOCS = README.gevel > REGRESS = gevel > include $(top_srcdir)/contrib/contrib-global.mk Oh ... well, there's your problem: it's not even *trying* to use PGXS. Replace it with this: MODULES = gevel DATA_built = gevel.sql DOCS = README.gevel REGRESS = gevel ifdef USE_PGXS PG_CONFIG = pg_config PGXS := $(shell $(PG_CONFIG) --pgxs) include $(PGXS) else subdir = contrib/gevel top_builddir = ../.. include $(top_builddir)/src/Makefile.global include $(top_srcdir)/contrib/contrib-global.mk endif ... and file a bug with the gevel authors, whoever they are, telling them to fix that upstream. regards, tom lane
Hi Tom, Thanks very much for your assistance, your suggestion worked a treat. I have updated the gevel people. Regards Andrew On 2010-09-23, at 2:05 PM, Tom Lane wrote: > Andrew Hunter <ahunter@ucalgary.ca> writes: >> Here is the content of the gevel Makefile > >> subdir = contrib/gevel >> top_builddir = ../.. >> include $(top_builddir)/src/Makefile.global > >> MODULES = gevel >> DATA_built = gevel.sql >> DOCS = README.gevel >> REGRESS = gevel > >> include $(top_srcdir)/contrib/contrib-global.mk > > Oh ... well, there's your problem: it's not even *trying* to use PGXS. > > Replace it with this: > > > MODULES = gevel > DATA_built = gevel.sql > DOCS = README.gevel > REGRESS = gevel > > ifdef USE_PGXS > PG_CONFIG = pg_config > PGXS := $(shell $(PG_CONFIG) --pgxs) > include $(PGXS) > else > subdir = contrib/gevel > top_builddir = ../.. > include $(top_builddir)/src/Makefile.global > include $(top_srcdir)/contrib/contrib-global.mk > endif > > > ... and file a bug with the gevel authors, whoever they are, > telling them to fix that upstream. > > regards, tom lane > > Andrew Hunter PEng RPSurv PhD Assistant Professor Department of Geomatics Engineering Schulich School of Engineering University of Calgary T: +403.220.7377 F: +403.284.1980 E: ahunter (at) ucalgary (dot) ca ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
We never expected gevel will be used by users :-) We'll fix. Oleg On Thu, 23 Sep 2010, Tom Lane wrote: > Andrew Hunter <ahunter@ucalgary.ca> writes: >> Here is the content of the gevel Makefile > >> subdir = contrib/gevel >> top_builddir = ../.. >> include $(top_builddir)/src/Makefile.global > >> MODULES = gevel >> DATA_built = gevel.sql >> DOCS = README.gevel >> REGRESS = gevel > >> include $(top_srcdir)/contrib/contrib-global.mk > > Oh ... well, there's your problem: it's not even *trying* to use PGXS. > > Replace it with this: > > > MODULES = gevel > DATA_built = gevel.sql > DOCS = README.gevel > REGRESS = gevel > > ifdef USE_PGXS > PG_CONFIG = pg_config > PGXS := $(shell $(PG_CONFIG) --pgxs) > include $(PGXS) > else > subdir = contrib/gevel > top_builddir = ../.. > include $(top_builddir)/src/Makefile.global > include $(top_srcdir)/contrib/contrib-global.mk > endif > > > ... and file a bug with the gevel authors, whoever they are, > telling them to fix that upstream. > > regards, tom lane > > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
Hi all, we are making some experiments with postgresql and postgis. We need to visualize R-trees and are trying to use GiST and gevel. During the installation phase of gevel we had the following output: sed 's,MODULE_PATHNAME,$libdir/gevel,g' gevel.sql.in >gevel.sql gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -I. -I../../src/include -c -o gevel.o gevel.c gevel.c: In function ‘gist_dumptree’: gevel.c:99: warning: format ‘%d’ expects type ‘int’, but argument 10 has type ‘Size’ gevel.c: In function ‘gist_tree’: gevel.c:134: error: too many arguments to function ‘stringToQualifiedNameList’ gevel.c: In function ‘gist_stat’: gevel.c:225: error: too many arguments to function ‘stringToQualifiedNameList’ gevel.c: In function ‘setup_firstcall’: gevel.c:325: error: too many arguments to function ‘stringToQualifiedNameList’ make: *** [gevel.o] Error 1 We are running Postgresql 8.4.4, can you please help us? Paolo & Waqas -- View this message in context: http://postgresql.1045698.n5.nabble.com/Visualize-GiST-Index-tp2849197p2855255.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Hi all, we are making some experiments with postgresql and postgis. We need to visualize R-trees and are trying to use GiST and gevel. During the installation phase of gevel we had the following output: sed 's,MODULE_PATHNAME,$libdir/gevel,g' gevel.sql.in >gevel.sql gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -I. -I../../src/include -c -o gevel.o gevel.c gevel.c: In function ‘gist_dumptree’: gevel.c:99: warning: format ‘%d’ expects type ‘int’, but argument 10 has type ‘Size’ gevel.c: In function ‘gist_tree’: gevel.c:134: error: too many arguments to function ‘stringToQualifiedNameList’ gevel.c: In function ‘gist_stat’: gevel.c:225: error: too many arguments to function ‘stringToQualifiedNameList’ gevel.c: In function ‘setup_firstcall’: gevel.c:325: error: too many arguments to function ‘stringToQualifiedNameList’ make: *** [gevel.o] Error 1 We are running Postgresql 8.4.4, can you please help us? Paolo & Waqas -- View this message in context: http://postgresql.1045698.n5.nabble.com/Visualize-GiST-Index-tp2849197p2855017.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Get gevel from cvs, address is on http://www.sai.msu.su/~megera/wiki/Gevel btw, have you seen http://www.sai.msu.su/~megera/wiki/Rtree_Index ? Oleg On Mon, 27 Sep 2010, paolo wrote: > > Hi all, > we are making some experiments with postgresql and postgis. We need to > visualize R-trees and are trying to use GiST and gevel. During the > installation phase of gevel we had the following output: > > > sed 's,MODULE_PATHNAME,$libdir/gevel,g' gevel.sql.in >gevel.sql > gcc -no-cpp-precomp -O2 -Wall -Wmissing-prototypes -Wpointer-arith > -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv > -I. -I../../src/include -c -o gevel.o gevel.c > gevel.c: In function ЪЪgist_dumptreeЪЪ: > gevel.c:99: warning: format ЪЪ%dЪЪ expects type ЪЪintЪЪ, but argument 10 has > type ЪЪSizeЪЪ > gevel.c: In function ЪЪgist_treeЪЪ: > gevel.c:134: error: too many arguments to function > ЪЪstringToQualifiedNameListЪЪ > gevel.c: In function ЪЪgist_statЪЪ: > gevel.c:225: error: too many arguments to function > ЪЪstringToQualifiedNameListЪЪ > gevel.c: In function ЪЪsetup_firstcallЪЪ: > gevel.c:325: error: too many arguments to function > ЪЪstringToQualifiedNameListЪЪ > make: *** [gevel.o] Error 1 > > > We are running Postgresql 8.4.4, can you please help us? > > Paolo & Waqas > Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
Oleg Bartunov <oleg@sai.msu.su> writes: > We never expected gevel will be used by users :-) It's very very useful when developing custom GiST indexes! -- dim
I firstly tried to "solve" the problem deleting the second parameter from all the calls to the stringToQualifiedNameList function, I wouldn't expect it, but.... it worked out, of course it was not the most elegant way. Oleg Bartunov wrote: > > Get gevel from cvs, address is on http://www.sai.msu.su/~megera/wiki/Gevel > Thanks, the version form cvs compiles fine, there are some differences in the when you make the installcheck but it works. I noticed that the expected output has been generated several months ago, so I supposed the differences can come from using different versions of postgresql. Oleg Bartunov wrote: > > btw, have you seen http://www.sai.msu.su/~megera/wiki/Rtree_Index ? > This also helps. Paolo Fogliaroni -- View this message in context: http://postgresql.1045698.n5.nabble.com/Visualize-GiST-Index-tp2849197p2857004.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.