[postgis-devel] [PostGIS] #1925: lwgeom_estimate.c: In function 'LWGEOM_gist_joinsel'
PostGIS
trac at osgeo.org
Wed Jul 18 09:36:40 PDT 2012
#1925: lwgeom_estimate.c: In function 'LWGEOM_gist_joinsel'
---------------------------------------------------+------------------------
Reporter: koshak | Owner: pramsey
Type: defect | Status: new
Priority: medium | Milestone: PostGIS 1.5.5
Component: postgis | Version: 1.5.X
Keywords: lwgeom_estimate.c LWGEOM_gist_joinsel |
---------------------------------------------------+------------------------
Comment(by koshak):
Replying to [comment:4 pramsey]:
> So you're saying that
> {{{
> /usr/local/include/postgresql/server/catalog/pg_class.h
> }}}
> exists? That's the path the compile step is searching for, but it's not
the path you put in above.
> How many instances of pg_config are on your system? (Look, this isn't a
postgis issues, it's a "your system" issue. You've almost certainly got
several installations of pgsql stuff lying around conflicting with one
another, so your postgis build is looking for components in places they
don't exist anymore)
{{{
[root at gizmo /usr/home/koshak/postgis-1.5.4]# locate pg_config
/usr/local/bin/pg_config
/usr/local/include/ecpg_config.h
/usr/local/include/pg_config.h
/usr/local/include/pg_config_manual.h
/usr/local/include/pg_config_os.h
/usr/local/include/postgresql/server/pg_config.h
/usr/local/include/postgresql/server/pg_config_manual.h
/usr/local/include/postgresql/server/pg_config_os.h
/usr/local/man/man1/pg_config.1.gz
/usr/local/share/locale/de/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/es/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/fr/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/it/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/ja/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/ko/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/nb/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/pt_BR/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/ro/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/ru/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/sv/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/ta/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/tr/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/zh_CN/LC_MESSAGES/pg_config-9.2.mo
/usr/local/share/locale/zh_TW/LC_MESSAGES/pg_config-9.2.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/doc/src/sgml/man1/pg_config.1
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/doc/src/sgml/ref
/pg_config-ref.sgml
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/.gitignore
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/Makefile
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/nls.mk
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/pg_config
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/pg_config.c
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/pg_config.o
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/cs.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/cs.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/de.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/de.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/es.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/es.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/fr.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/fr.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/it.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/it.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ja.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ja.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ko.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ko.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/nb.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/nb.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/pl.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/pl.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/pt_BR.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/pt_BR.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ro.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ro.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ru.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ru.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/sv.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/sv.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ta.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/ta.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/tr.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/tr.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/zh_CN.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/zh_CN.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/zh_TW.mo
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/bin/pg_config/po/zh_TW.po
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/include/pg_config.h
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/include/pg_config.h.in
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/include/pg_config.h.win32
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/include/pg_config_manual.h
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/include/pg_config_os.h
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/interfaces/ecpg/include/ecpg_config.h
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/interfaces/ecpg/include/ecpg_config.h.in
/usr/ports/databases/postgresql90-client/work/postgresql-9.0.8/src/port/pg_config_paths.h
}}}
But i wrote my pkg_info:
[root at gizmo /usr/home/koshak]# pkg_info | grep sql
{{{
apr-ipv6-devrandom-gdbm-db42-pgsql92-1.4.5.1.3.12_1 Apache Portability
Library
mysql-client-5.0.95 Multithreaded SQL database (client)
mysql-server-5.0.95 Multithreaded SQL database (server)
postgresql-client-9.2.b2 PostgreSQL database (client)
postgresql-contrib-9.2.b2 The contrib utilities from the PostgreSQL
distribution
postgresql-server-9.2.b2 The most advanced open-source database available
anywhere
}}}
And output pg_config:
{{{
[root at gizmo /home/koshak/postgis-1.5.4]# pg_config
BINDIR = /usr/local/bin
DOCDIR = /usr/local/share/doc/postgresql
HTMLDIR = /usr/local/share/doc/postgresql
INCLUDEDIR = /usr/local/include
PKGINCLUDEDIR = /usr/local/include/postgresql
INCLUDEDIR-SERVER = /usr/local/include/postgresql/server
LIBDIR = /usr/local/lib
PKGLIBDIR = /usr/local/lib/postgresql
LOCALEDIR = /usr/local/share/locale
MANDIR = /usr/local/man
SHAREDIR = /usr/local/share/postgresql
SYSCONFDIR = /usr/local/etc/postgresql
PGXS = /usr/local/lib/postgresql/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--with-libraries=/usr/local/lib' '--with-
includes=/usr/local/include' '--enable-thread-safety' '--with-openssl'
'--with-libxml' '--enable-nls' '--without-gssapi' '--prefix=/usr/local' '
--mandir=/usr/local/man' '--infodir=/usr/local/info/' '--build=i386
-portbld-freebsd8.2' 'build_alias=i386-portbld-freebsd8.2' 'CC=cc'
'CFLAGS=-O2 -pipe -fno-strict-aliasing' 'LDFLAGS= -L/usr/local/lib
-rpath=/usr/lib:/usr/local/lib' 'CPPFLAGS=' 'CPP=cpp' 'LDFLAGS_SL='
CC = cc
CPPFLAGS = -I/usr/local/include/libxml2 -I/usr/local/include
-I/usr/local/include -I/usr/local/include
CFLAGS = -O2 -pipe -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-
format-attribute -Wformat-security -fno-strict-aliasing -fwrapv
CFLAGS_SL = -fPIC -DPIC
LDFLAGS = -L/usr/local/lib -rpath=/usr/lib:/usr/local/lib -L/usr/local/lib
-L/usr/local/lib -L/usr/local/lib -Wl,--as-needed -Wl,-R'/usr/local/lib'
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgport -lintl -lxml2 -lssl -lcrypto -lz -lreadline -lcrypt -lm
VERSION = PostgreSQL 9.2beta2
}}}
I don't know how to fix that problem :( Could u help me?
I don't know how to fix that problem :( Could u help me?
I ntried to find from where pg_class.h included, but can't find
{{{
[root at gizmo /home/koshak/postgis-1.5.4]# grep -r pg_class * | grep -v
"\.sql"
extras/template_gis/postgres_lib.sh.in: psql -d $TDB -c
"update pg_class set relowner=$GRID where relkind = 'S';" 2>&1 | cat >
/dev/null
extras/WFS_locks/WFS_locks.c: sprintf(query,"SELECT * FROM pg_class
WHERE relname = 'temp_lock_have_table'");
loader/pgsql2shp.c: sprintf(query, "SELECT oid FROM pg_class
c, pg_namespace n WHERE c.relnamespace n.oid AND n.nspname = '%s' AND
c.relname = '%s'", schema, table);
loader/pgsql2shp.c: sprintf(query, "SELECT oid FROM pg_class
WHERE relname = '%s'", table);
loader/pgsql2shp.c: "pg_attribute a, pg_class c,
pg_namespace n WHERE "
loader/pgsql2shp.c: "pg_attribute a, pg_class c WHERE
"
postgis/geography_estimate.c: * Could be used to get reltuples
from pg_class (which
postgis/long_xact.c: sprintf(query,"SELECT * FROM pg_class WHERE
relname = 'temp_lock_have_table'");
postgis/lwgeom_estimate.c: Form_pg_class reltup =
(Form_pg_class) GETSTRUCT(class_tuple);
postgis/lwgeom_estimate.c: Form_pg_class reltup =
(Form_pg_class) GETSTRUCT(class_tuple);
postgis/lwgeom_estimate.c: * Could be used to get reltuples from
pg_class (which
postgis/lwgeom_estimate.c: sprintf(query, "SELECT
s.stanumbers1[5:8] FROM pg_statistic s, pg_class c, pg_attribute a,
pg_namespace n WHERE c.relname = '%s' AND a.attrelid = c.oid AND a.attname
= '%s' AND n.nspname = '%s' AND c.relnamespace = n.oid AND
s.starelid=c.oid AND s.staattnum = a.attnum AND staattnum = attnum", tbl,
col, nsp);
postgis/lwgeom_estimate.c: sprintf(query, "SELECT
s.stanumbers1[5:8] FROM pg_statistic s, pg_class c, pg_attribute a,
pg_namespace n WHERE c.relname = '%s' AND a.attrelid = c.oid AND a.attname
= '%s' AND n.nspname = current_schema() AND c.relnamespace = n.oid AND
s.starelid=c.oid AND s.staattnum = a.attnum AND staattnum = attnum", tbl,
col);
utils/profile_intersects.pl:# get number of features from pg_class.ntuples
utils/profile_intersects.pl:$query = 'SELECT c.reltuples FROM pg_class c,
pg_namespace n '.
utils/test_estimation.pl:# get number of features from pg_class.ntuples
utils/test_estimation.pl:$query = 'SELECT c.reltuples FROM pg_class c,
pg_namespace n '.
utils/test_geography_estimation.pl:# get number of features from
pg_class.ntuples
utils/test_geography_estimation.pl:$query = 'SELECT c.reltuples FROM
pg_class c, pg_namespace n '.
utils/test_geography_joinestimation.pl:# get number of features from
pg_class.ntuples
utils/test_geography_joinestimation.pl: my $query = 'SELECT c.reltuples
FROM pg_class c, pg_namespace n '.
utils/test_joinestimation.pl:# get number of features from
pg_class.ntuples
utils/test_joinestimation.pl: my $query = 'SELECT c.reltuples FROM
pg_class c, pg_namespace n '.
}}}
--
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1925#comment:6>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-devel
mailing list