On 11/14/2012 09:03 AM, Jeff Janes wrote:
> On Wed, Nov 14, 2012 at 8:44 AM, Rhys A.D. Stewart
> <rhys.stewart@gmail.com> wrote:
>> Greetings all,
>>
>> having a permission issue with writing a file using plpython to a local
>> folder, changed permissions to everyone read and write and even changed the
>> owner to postgres. but no joy, any suggestions?
>
> plpython is a "trusted" langauge. That means pgsql trusts it not to
> allow you to break out of the sandbox and interact directly with the
> file system or the database server internals.
>
> If you need to do those things, you can use plpythonu.
My understanding is that of Postgres 7.4 plpython does not exist. In
other words only the untrusted version is available.
>
> Cheers,
>
> Jeff
>
>
--
Adrian Klaver
adrian.klaver@gmail.com