Re: pl/java status

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