Обсуждение: PostgreSQL 8.4.1 and pljava

Поиск
Список
Период
Сортировка

PostgreSQL 8.4.1 and pljava

От
Mladen Gogala
Дата:
I was trying to find the packaged version of pljava for postgresql 8.4.1, no luck. Compilation from the source code is also a problem, there is no "configure" utility, it's a manual process. Does anybody know more about that? Where can I get pljava for the latest version of pgsql?

VMSMladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com




The Leader in Integrated Media Intelligence Solutions




Вложения

Re: PostgreSQL 8.4.1 and pljava

От
Richard Broersma
Дата:
On Tue, Nov 24, 2009 at 8:28 AM, Mladen Gogala <mladen.gogala@vmsinfo.com> wrote:

I was trying to find the packaged version of pljava for postgresql 8.4.1, no luck. Compilation from the source code is also a problem, there is no "configure" utility, it's a manual process. Does anybody know more about that? Where can I get pljava for the latest version of pgsql?

The official website for the pl/java project is: http://pgfoundry.org/projects/pljava/

If you don't get a good answer to your questions from this mailing list, you might try re-posting your email to the following lists:

pljava-dev@pgfoundry.org
pgsql-jdbc@postgresql.org

These mailings lists are more likely to have people experienced with pl/java who can answer your questions.

--
Regards,
Richard Broersma Jr.

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

Re: PostgreSQL 8.4.1 and pljava

От
Richard Broersma
Дата:
On Tue, Nov 24, 2009 at 9:13 AM, Mladen Gogala <mladen.gogala@vmsinfo.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@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