PL/Java language support about pg_tle HOT 5 CLOSED

Hi @domenico1982 -- we actually don't list out specific trusted languages that work with pg_tle in the docs, though we do provide examples of writing TLEs with a few of them. As noted in the security section of the docs:

Use pg_tle with trusted languages. While pg_tle can work with untrusted languages, trusted languages in PostgreSQL provide more protections for user-provided code.

Implicitly, you can write TLEs with PL/Java so long as your environment has PL/Java installed. Perhaps we can add in the README a comment about how TLE applies to trusted languages in genera. However, unless we have specific examples built on in the docs of pg_tle being used with another language, I don't know if we should list all of the languages out.

from pg_tle.

Hi @domenico1982 PL/Java is also somewhat unique in that it requires a JVM to exist on the host. I guess you would only run this on your hosts that actually had a JVM ?

from pg_tle.

Hi Dave, yeah, you're right. We're only wondering if this will ever be supported with RDS/Aurora. Thanks for your support, both answers are clear and valuable.

from pg_tle.

@domenico1982 Thanks for the feedback. I am going to close out this issue.

from pg_tle.

@domenico1982 PL/Java hasn't seen much love lately. I'm wondering just how much it is used. Obviously you are using it, do you have any notion how popular it is ?

from pg_tle.