On Wed, Nov 14, 2012 at 8:44 AM, Rhys A.D. Stewart
<rhys(dot)stewart(at)gmail(dot)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.
Cheers,
Jeff