Re: Attention PL authors: want to be listed in template table?

From: Thomas Hallgren <thhal(at)mailblocks(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Attention PL authors: want to be listed in template table?
Date: 2005-09-07 22:55:32
Message-ID: thhal-0Zwj7Aw3E8LQzh7AEsISiZZf0j7KYTx@mailblocks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

>Peter Eisentraut <peter_e(at)gmx(dot)net> writes:
>
>
>>The other problem I see emerging here is that in certain environments,
>>the "java" language may not be trusted, such as when it is compiled
>>with GCJ.
>>
>>
Well, yes. But use the word environment in singular please :-) To my
knowledge the security is full-proof with all other VM's since they all
use the standard runtime libraries. The GCJ support is as experimental
as the GCJ in itself and cannot be trusted in production.

>
>Hmm, is that really the case? I thought Java is Java.
>
>
GCJ is a clean house implementation of Java. They don't use the runtime
libraries from Sun and they are not really there yet in their efforts to
copy the functionality. One of the things that lag behind is security.
They hope to have a better security implementation before the year end
but there's no promise.

>>Then, this built-in template will override the CREATE
>>LANGUAGE specification and introduce a security hole.
>>
>>
>
>But it's exactly the same hole the user would create by manually saying
>CREATE TRUSTED LANGUAGE in error. I don't think that's a reasonable
>argument against the template idea --- it just says that you have to be
>aware of what you're doing.
>
>(An appropriate solution, in my mind, would be to drop the trusted call
>handler from the shared library if it's built with gcj --- then there's
>really no possibility of doing the wrong thing.)
>
>
That's a though although I'm not sure we would gain anything. No PL/Java
binaries are provided that run with GCJ. You have to compile from source
using some specific settings. If you are skilled enough to experiment
with that, then there's a good chance you are able to tweak the source
to enable the trusted call handler also.

Regards,
Thomas Hallgren

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-09-07 23:02:32 Re: Attention PL authors: want to be listed in template table?
Previous Message Andrew Dunstan 2005-09-07 22:52:39 Re: pg_config/share_dir