Greg Smith wrote:
John R Pierce wrote:
is pl/java kind of dead? I don't see much activity since years ago.
this page seems quite out of date, talking about 1.1.0b1 released,
but the foundry has 1.4.0 from 2008 that supports 8.3. only
The last set of commits there was about 9 months ago, so it's not
quite as dead as it appears. The code in CVS supports 8.4, there just
hasn't been an official release in a while:
http://pgfoundry.org/tracker/?func=detail&atid=335&aid=1010695&group_id=1000038
There are a couple of bugs to note at
http://pgfoundry.org/tracker/?atid=334&group_id=1000038&func=browse
like lack of support for JDK 1.6 and some known complier issues.
is there a pl/java mail list? I've started to begin to commence to try
to compile this stuff, I checked out the whole thing from CVS and when I
run make, I'm getting an error that there's missing files in the
postgres tree. I'm using the 8.4-community tarball for 64bit
postgresql from the postgres website, am I instead going to have to
build my own?
~/org.postgresql.pljava]$ gmake
gmake[1]: Entering directory
`/export/home/piercej/org.postgresql.pljava/build/classes/pljava'
gmake[1]: Nothing to be done for `all'.
gmake[1]: Leaving directory
`/export/home/piercej/org.postgresql.pljava/build/classes/pljava'
gmake[1]: Entering directory
`/export/home/piercej/org.postgresql.pljava/build/classes/deploy'
gmake[1]: Nothing to be done for `all'.
gmake[1]: Leaving directory
`/export/home/piercej/org.postgresql.pljava/build/classes/deploy'
gmake[1]: Entering directory
`/export/home/piercej/org.postgresql.pljava/build/objs'
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk:59:
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.global:
No such file or directory
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk:84:
/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.shlib:
No such file or directory
gmake[1]: *** No rule to make target
`/usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/../../src/Makefile.shlib'.
Stop.
gmake[1]: Leaving directory
`/export/home/piercej/org.postgresql.pljava/build/objs'
gmake: *** [c_all] Error 2
this is on Solaris 10, UltraSparc, with SunStudio installed. the
postgres is the 8.4 community build, but I do note its only 8.4.1, and I
really should upgrade it to 8.4.3....
....20 mins later, upgraded to 8.4.3, and still getting same error.
pg_config says...
$ pg_config
BINDIR = /usr/postgres/8.4-community/bin/64
DOCDIR = /usr/postgres/8.4-community/share/doc
HTMLDIR = /usr/postgres/8.4-community/share/doc
INCLUDEDIR = /usr/postgres/8.4-community/include
PKGINCLUDEDIR = /usr/postgres/8.4-community/include
INCLUDEDIR-SERVER = /usr/postgres/8.4-community/include/server
LIBDIR = /usr/postgres/8.4-community/lib/64
PKGLIBDIR = /usr/postgres/8.4-community/lib/64
LOCALEDIR = /usr/postgres/8.4-community/share/locale
MANDIR = /usr/postgres/8.4-community/man
SHAREDIR = /usr/postgres/8.4-community/share
SYSCONFDIR = /usr/postgres/8.4-community/etc
PGXS = /usr/postgres/8.4-community/lib/64/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--prefix=/usr/postgres/8.4-community'
'--exec-prefix=/usr/postgres/8.4-community'
'--bindir=/usr/postgres/8.4-community/bin/64'
'--libexecdir=/usr/postgres/8.4-community/bin/64'
'--sbindir=/usr/postgres/8.4-community/bin/64'
'--datadir=/usr/postgres/8.4-community/share'
'--sysconfdir=/usr/postgres/8.4-community/etc'
'--mandir=/usr/postgres/8.4-community/man'
'--libdir=/usr/postgres/8.4-community/lib/64'
'--includedir=/usr/postgres/8.4-community/include'
'--sharedstatedir=/var/postgres/8.4-community'
'--localstatedir=/var/postgres/8.4-community'
'--with-system-tzdata=/usr/share/lib/zoneinfo' '--enable-nls'
'--with-docdir=/usr/postgres/8.4-community/doc' '--with-python'
'--with-pam' '--with-openssl' '--with-libedit-preferred' '--with-libxml'
'--with-libxslt' '--with-gssapi' '--enable-thread-safety'
'--enable-dtrace' 'DTRACEFLAGS=-64'
'--with-includes=/zstore/pgsql/pg84b1/proto/root_sparc/usr/include:/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include:/usr/sfw/include'
'--with-tclconfig=/usr/sfw/lib'
'--with-libs=/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64:/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64:/usr/lib/64:/usr/sfw/lib/64'
'CC=/opt/SUNWspro/SS11/bin/cc' 'CFLAGS=-xO3 -xarch=v9 -dalign
-Wc,-Qiselect-regsym=0 -xspace -W0,-Lt -W2,-Rcond_elim -Xa -xildoff '
'LDFLAGS=-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64
-L/usr/sfw/lib/64'
'CPPFLAGS=-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include'
CC = /opt/SUNWspro/SS11/bin/cc
CPPFLAGS = -I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include
-I/usr/sfw/include -I/usr/include/libxml2
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/include
-I/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/include -I/usr/sfw/include
CFLAGS = -xO3 -xarch=v9 -dalign -Wc,-Qiselect-regsym=0 -xspace -W0,-Lt
-W2,-Rcond_elim -Xa -xildoff
CFLAGS_SL = -KPIC
LDFLAGS = -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/zstore/pgsql/pg84b1/proto/root_sparc/usr/sfw/lib/64 -L/usr/sfw/lib/64
-L/usr/lib -L/zstore/pgsql/pg84b1/proto/root_sparc/usr/lib/64
-L/usr/lib/64 -L/usr/sfw/lib/64 -Wl,-R'/usr/postgres/8.4-community/lib/64'
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgss -lz -ledit
-ltermcap -lnsl -lrt -lsocket -lm
VERSION = PostgreSQL 8.4.3
.... my CC is...
$ which cc
/opt/SUNWspro/bin/cc
$ cc -V
cc: Sun C 5.9 SunOS_sparc Patch 124867-12 2009/11/22
usage: cc [ options] files. Use 'cc -flags' for details
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general