On 11/15/2012 01:08 AM, Adrian Klaver wrote: > On 11/14/2012 09:03 AM, Jeff Janes wrote: >> On Wed, Nov 14, 2012 at 8:44 AM, Rhys A.D. Stewart >> <rhys.stew...@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.
... and that's because Python's design - in particular, the introspection features - means the the restricted mode wasn't particularly restricted. See http://docs.python.org/2/library/restricted.html , http://wiki.python.org/moin/SandboxedPython . -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
