Re: [GENERAL] PLJava for Postgres 9.2.

Thx.

Yes, am aware PLJava is a 3rd party lib, just surprised the same party hasn't built them given they seem to be built all the way to 9.1.

My question was primarily about obtaining pgsx.mk file which is a part of the PostgreSQL project.

Paul

________________________________
From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Paul Hammond <hammpaul70(at)yahoo(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>; "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Sent: Friday, 17 May 2013, 0:03
Subject: Re: [GENERAL] [HACKERS] PLJava for Postgres 9.2.

On 05/16/2013 05:59 PM, Paul Hammond wrote:
> Hi all,
>
> I've downloaded PLJava, the latest version, which doesn't seem to have
> a binary distribution at all for 9.2, so I'm trying to build it from
> the source for Postgres 9.2. I have the DB itself installed on Windows
> 7 64 bit as a binary install. I've had to do a fair bit of hacking
> with the makefiles on cygwin to get PLJava to build, but I have
> succeeded in compiling the Java and JNI code, the pljava_all and
> deploy_all targets effectively.

Cygwin is not a recommended build platform for native Windows builds.
See the docs for the recommended ways to build Postgres.

>
> But I'm coming unstuck at the next target where it's doing the target
> c_all. It's trying to find the following makefile in the Postgres dist:
>
> <my postgres installation dir>/lib/pgxs/src/makefiles/pgxs.mk: No such
> file or directory
>
> What do I need to do to obtain the required files, and does anybody
> know why, given Postgres 9.2 is out some time, and 9.3 is in beta, why
> no prebuild binary PLJavas exist for 9.2?

Because nobody has built them?

FYI, PL/Java is not maintained by the PostgreSQL project.

cheers

andrew