Re: PostgreSQL 8.4.1 and pljava

On Tue, Nov 24, 2009 at 9:13 AM, Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>wrote:

> Richard, the source code doesn't compile:
>
> cc -c -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g
> -fpic -I. -I/usr/include/postgresql/8.4/server
> -I/usr/include/postgresql/internal -D_GNU_SOURCE -I/usr/include/libxml2
> -I/usr/include/tcl8.5 -DPKGLIBDIR=\"/usr/lib/postgresql/8.4/lib\"
> -I/home/mgogala/Downloads/pljava-1.4.0/src/C/include
> -I/home/mgogala/Downloads/pljava-1.4.0/build/jni -DPGSQL_MAJOR_VER=8
> -DPGSQL_MINOR_VER=4 -DPGSQL_PATCH_VER=1 -I"/usr/lib/jvm/java-gcj/include"
> -I"/usr/lib/jvm/java-gcj/include/linux"
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c -o
> SubXactListener.o
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c:19:
> error: expected ‘)’ before ‘event’
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c: In
> function ‘Java_org_postgresql_pljava_internal_SubXactListener__1register’:
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c:80:
> warning: implicit declaration of function ‘RegisterSubXactCallback’
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c:80:
> error: ‘subXactCB’ undeclared (first use in this function)
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c:80:
> error: (Each undeclared identifier is reported only once
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c:80:
> error: for each function it appears in.)
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c: In
> function ‘Java_org_postgresql_pljava_internal_SubXactListener__1unregister’:
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c:103:
> warning: implicit declaration of function ‘UnregisterSubXactCallback’
> /home/mgogala/Downloads/pljava-1.4.0/src/C/pljava/SubXactListener.c:103:
> error: ‘subXactCB’ undeclared (first use in this function)
> make[1]: *** [SubXactListener.o] Error 1
> make[1]: Leaving directory
> `/home/mgogala/Downloads/pljava-1.4.0/build/objs'
> make: *** [c_all] Error 2
> mgogala(at)nycwxp2622:~/Downloads/pljava-1.4.0$
>

Unfortunately, I'm not experienced with pl/java or building software so I
will not be able to offer you much help. I see that you reply'd only to me
so I re-cc'd the pgsql-novice mailing lists so that others subscribed to
this mailing list can participate. Make sure you reply-all so that others
subscribing to this mailing list are included in the conversation.

I'm using PostgreSQL V8.4 on Windows using pre-built binarys that are
managed with the EnterpriseDB contributed "Stack-building" application. I
notice that PL/Java is no longer included as a PostgreSQL extension as it
was for PostgreSQL Version 8.1 thru 8.3. Perhaps there wasn't enough
community support to building a version that would work with PG 8.4.
However, I'm only guessing as to why PL/Java was not 'ported'(is this the
correct word to use here?) to version 8.4

The persons that can give you a definitive answer to your question are found
on the previously mentioned mailing lists. I hope this helps.

--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug