PostgreSQL 11 and PL/Java: it can work!


If you are in a rush and want to experiment with PL/Java 1.5.1 Beta and PostgreSQL 11, have a look at this pull request.

Trying to compile PL/Java against PG11b2

First of all, I’m used to serve PostgreSQL over FreeBSD, and this is not the optimal situation because a lot of code is written with Linux in mind and requires some adjustements when compiled/ported over other Unix implementations. PL/Java is an example: it compiles thru Apache Maven, that in turn seems to require GCC, that is not the default compiler on FreeBSD and … you get the point.

However, with a little work, it is possible to compile PL/Java even on FreeBSD (as you can imagine) and this is what I’ve done so far. But last monday, trying to compile it against PostgreSQL 11 beta 2, quickly resulted in frustation.

Luckily, and thanks to the great PL/Java, I found that due to a change in the PostgreSQL 11 GUC definition, things could have been adjusted to make it compiling. After one day, all of my PL/Java code seemed to be running fine with this simple workaround (and yes, I don’t have code that complex, so this does not mean the workaround is production safe!). I therefore decided to open a pull request about it.

Shame on me!
My pull request resulted in a mess, because I made it against the right branch and tag. And in the meantime, I didn’t noticed that the right pull request was added by someone realy much more competente than me on this subject: Chapman Flack. Thanks Chapman, hope things will be fixed soon!

The article PostgreSQL 11 and PL/Java: it can work! has been posted by Luca Ferrari on July 25, 2018