Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 312171

Summary: dev-db/postgis-1.3.1 does not compile against dev-db/postgresql-server-8.4.2-r1
Product: Gentoo Linux Reporter: Stijn Tintel <stijn+gentoo>
Component: Current packagesAssignee: PgSQL Bugs <pgsql-bugs>
Status: RESOLVED INVALID    
Severity: major CC: esigra, pierre42d, sci-geosciences, vincent
Priority: High    
Version: unspecified   
Hardware: AMD64   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---
Attachments: dev-db/postgis-1.3.1 build.log
prevent postgis-1.3.1 from attempting to build against postgresql-server-8.4

Description Stijn Tintel 2010-03-30 18:50:52 UTC
dev-db/postgis-1.3.1 (which is the only version marked amd64) does not compile against dev-db/postgresql-server-8.4.2-r1 (which is the latest version marked amd64, and thus the one that's installed by default).


Reproducible: Always

Steps to Reproduce:
1. emerge postgresql-server postgis
Actual Results:  
86_64-pc-linux-gnu-gcc -pipe -O2 -march=core2 -msse4.1 -ggdb -DUSE_VERSION=83 -DPOSTGIS_LIB_VERSION='"1.3.1"' -DPOSTGIS_VERSION='"1.3 USE_GEOS=0 USE_PROJ=0 USE_STATS=1"' -DPOSTGIS_SCRIPTS_VERSION='"1.3.1"' -DPOSTGIS_BUILD_DATE='"2010-03-30 18:43:07"' -I/usr/include/postgresql-8.4/server -DAUTOCACHE_BBOX=1  -DUSE_STATS -Wall -g -O2 -fPIC -fexceptions    -c -o lwgeom_functions_basic.o lwgeom_functions_basic.c
lwgeom_estimate.c: In function ‘build_lwhistogram2d’:
lwgeom_estimate.c:376: error: ‘textout’ undeclared (first use in this function)
lwgeom_estimate.c:376: error: (Each undeclared identifier is reported only once
lwgeom_estimate.c:376: error: for each function it appears in.)
lwgeom_estimate.c: In function ‘explode_lwhistogram2d’:
lwgeom_estimate.c:593: error: ‘textout’ undeclared (first use in this function)
lwgeom_estimate.c: In function ‘LWGEOM_gist_joinsel’:
lwgeom_estimate.c:822: error: ‘PlannerInfo’ undeclared (first use in this function)
lwgeom_estimate.c:822: error: ‘root’ undeclared (first use in this function)
lwgeom_estimate.c:822: error: expected expression before ‘)’ token
lwgeom_estimate.c:896: warning: implicit declaration of function ‘SearchSysCache’
lwgeom_estimate.c:896: error: ‘STATRELATT’ undeclared (first use in this function)
lwgeom_estimate.c:896: warning: assignment makes pointer from integer without a cast
lwgeom_estimate.c:914: warning: implicit declaration of function ‘ReleaseSysCache’
lwgeom_estimate.c:920: warning: assignment makes pointer from integer without a cast
lwgeom_estimate.c:983: error: ‘RELOID’ undeclared (first use in this function)
lwgeom_estimate.c:984: warning: assignment makes pointer from integer without a cast
lwgeom_estimate.c:996: warning: assignment makes pointer from integer without a cast
lwgeom_estimate.c: In function ‘LWGEOM_gist_sel’:
lwgeom_estimate.c:1698: error: ‘PlannerInfo’ undeclared (first use in this function)
lwgeom_estimate.c:1698: error: ‘root’ undeclared (first use in this function)
lwgeom_estimate.c:1698: error: expected expression before ‘)’ token
lwgeom_estimate.c:1797: error: ‘STATRELATT’ undeclared (first use in this function)
lwgeom_estimate.c:1797: warning: assignment makes pointer from integer without a cast
lwgeom_estimate.c: In function ‘LWGEOM_estimated_extent’:
lwgeom_estimate.c:2445: error: ‘ArrayType’ undeclared (first use in this function)
lwgeom_estimate.c:2445: error: ‘array’ undeclared (first use in this function)
lwgeom_estimate.c:2582: error: expected expression before ‘)’ token
lwgeom_estimate.c:2591: warning: implicit declaration of function ‘ArrayGetNItems’
lwgeom_estimate.c:2591: warning: implicit declaration of function ‘ARR_NDIM’
lwgeom_estimate.c:2591: warning: implicit declaration of function ‘ARR_DIMS’
lwgeom_estimate.c:2609: warning: implicit declaration of function ‘ARR_DATA_PTR’
lwgeom_estimate.c:2609: warning: passing argument 2 of ‘memcpy’ makes pointer from integer without a cast
make[1]: *** [lwgeom_estimate.o] Error 1
make[1]: *** Waiting for unfinished jobs....
make[1]: Leaving directory `/var/tmp/portage/dev-db/postgis-1.3.1/work/postgis-1.3.1/lwgeom'
make: *** [liblwgeom] Error 2



taz ~ # emerge --info =dev-db/postgis-1.3.1
Portage 2.1.7.17 (default/linux/amd64/10.0/desktop, gcc-4.3.4, glibc-2.10.1-r1, 2.6.33-gentoo x86_64)
=================================================================
                        System Settings
=================================================================
System uname: Linux-2.6.33-gentoo-x86_64-Intel-R-_Core-TM-2_Duo_CPU_E8400_@_3.00GHz-with-gentoo-2.0.1
Timestamp of tree: Sun, 28 Mar 2010 21:45:02 +0000
distcc 3.1 x86_64-pc-linux-gnu [disabled]
app-shells/bash:     4.0_p35
dev-java/java-config: 2.1.10
dev-lang/python:     2.5.4-r4, 2.6.4-r1
dev-python/pycrypto: 2.1.0_beta1
dev-util/cmake:      2.6.4-r3
sys-apps/baselayout: 2.0.1
sys-apps/openrc:     0.6.1-r1
sys-apps/sandbox:    1.6-r2
sys-devel/autoconf:  2.13, 2.63-r1
sys-devel/automake:  1.6.3, 1.8.5-r3, 1.9.6-r2, 1.10.3
sys-devel/binutils:  2.18-r3
sys-devel/gcc:       4.3.4
sys-devel/gcc-config: 1.4.1
sys-devel/libtool:   2.2.6b
virtual/os-headers:  2.6.30-r1
ACCEPT_KEYWORDS="amd64"
ACCEPT_LICENSE="* -@EULA dlj-1.1 skype-eula"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-pipe -O2 -march=core2 -msse4.1 -ggdb"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/share/X11/xkb /var/lib/hsqldb"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/env.d/java/ /etc/eselect/postgresql /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/splash /etc/terminfo"
CXXFLAGS="-pipe -O2 -march=core2 -msse4.1 -ggdb"
DISTDIR="/usr/portage/distfiles"
FEATURES="assume-digests distlocks fixpackages news parallel-fetch protect-owned sandbox sfperms splitdebug strict unmerge-logs unmerge-orphans userfetch"
GENTOO_MIRRORS="http://mirrors.nl.eu.kernel.org/gentoo/"
LANG="en_US.UTF-8"
LDFLAGS="-Wl,-O1"
LINGUAS="en en_US en_GB nl"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage/layman/desktop-effects /usr/local/portage/layman/sunrise /usr/local/portage/layman/zugaina /usr/local/portage/layman/rion /usr/local/portage/stintel"
SYNC="rsync://mirrors.nl.eu.kernel.org/gentoo-portage/"
USE="7zip X a52 aac acl acpi aio alac alsa amd64 apache2 applet async atm avahi bash-completion berkdb bluetooth branding bzip2 cairo caps cddb cdparanoia cdr cdrkit cli consolekit cracklib crypt cscope css cups curl custom-optimization cxx daap dbus dri dts dv dvb dvd dvdr emboss enca encode examples exif fam fbsplash ffmpeg flac fontconfig foomaticdb ftp fuse galago gcc4 gcj gconf gdbm gdm gif gimp gimpprint git glib glitz gnome gnome-keyring gnome-print gnutls gphoto2 gpm graphviz gstreamer gtk gtk2 gtkhtml gupnp hal hddtemp hfs http iconv idn ieee1394 imagemagick imap inotify ipod iproute2 ipv6 ithreads java java6 jpeg jpeg2k keyring kvm lame laptop lcms ldap libnotify lm_sensors logrotate lua lvm lzma lzo mad matroska midi mikmod mmap mmx mng modules mono mozbranding mp3 mp4 mpeg mpi mpi-threads msn mtp mudflap multilib mysql nas nautilus ncurses network network-cron networkmanager nfs nls nptl nptlonly nsplugin ntp obex offensive ogg openal openct openexr opengl openmp pam pcre pcsc-lite pdf perl php pkcs11 plotutils pm-utils pmu png policykit posix ppds pppd prelude pulseaudio python qt3support quicktime rar readline reflection resolvconf rtc samba scanner sdl server session sharedmem slp smartcard smp snmp sockets socks5 spell spl srt sse sse2 sse3 ssl ssse3 startup-notification subversion svg sysfs taglib tcpd tetex theora threads thunar thunderbird tiff truetype truetype-fonts udev unicode upnp urandom usb v4l2 vim vim-syntax vorbis webdav widescreen wifi wma wmf x264 xattr xcomposite xforms xfs xml xml2 xmp xorg xprint xulrunner xv xvid zeroconf zip zlib" ALSA_CARDS="emu10k1x hda-intel" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" APACHE2_MPMS="worker" CAMERAS="ptp2" ELIBC="glibc" INPUT_DEVICES="evdev keyboard mouse" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en en_US en_GB nl" QEMU_SOFTMMU_TARGETS="i386 x86_64" QEMU_USER_TARGETS="i386 x86_64" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="dummy nouveau" 
Unset:  CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, FFLAGS, INSTALL_MASK, LC_ALL, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

taz ~ # emerge -pqv =dev-db/postgis-1.3.1
[ebuild  N    ] dev-db/postgis-1.3.1  USE="-doc -geos -proj" 

 * IMPORTANT: 1 news items need reading for repository 'gentoo'.
 * Use eselect news to read news items.
Comment 1 Stijn Tintel 2010-03-30 18:52:16 UTC
Created attachment 225869 [details]
dev-db/postgis-1.3.1 build.log
Comment 2 Stéphan BERNARD 2010-06-15 08:07:34 UTC
I have the same error with postgis-1.3.1. Unmasking dev-db/postgis-1.3.6-r1 compiles well with postgres 8.4.

Saw this at http://postgis.refractions.net/pipermail/postgis-devel/2009-February/004879.html (seems to be the same error):
"Build gets fixed by adding following four lines into the file
lwgeom/lwgeom_estimate.c

#include "utils/selfuncs.h"
#include "utils/syscache.h"
#include "utils/guc.h"
extern Datum textout (PG_FUNCTION_ARGS);"

Hope this helps.
Comment 3 Vicente Olivert Riera (RETIRED) gentoo-dev 2010-08-01 15:54:33 UTC
In the official PostGIS manual you can found this:


A.1.1 Release 1.3.6
Release date: 2009/05/04
This release adds support for PostgreSQL 8.4, exporting prj files from the database with shape data, and several small bug fixes
in the handling of "curve" types.


So..., versions < 1.3.6 hasn't support to PostgreSQL 8.4. I think if 8.4 is the  last current stable version in portage tree, postgis-1.3.6 should be marked as stable.
Comment 4 Aaron W. Swenson gentoo-dev 2011-05-01 01:36:41 UTC
dev-db/postgis-1.3.6 added support for PostgreSQL 8.4. Versions prior to that did not.
Comment 5 jez austin 2011-07-06 11:17:20 UTC
Created attachment 279207 [details, diff]
prevent postgis-1.3.1 from attempting to build against postgresql-server-8.4