Re: [GENERAL] Access disk from plpython

2012-11-14 Thread Craig Ringer
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 >> wrote: >>> Greetings all, >>> >>> having a permission issue with writing a file using plpython to a local >>> folder, changed permissions to everyone re

Re: [GENERAL] Access disk from plpython

2012-11-14 Thread Adrian Klaver
On 11/14/2012 08:56 AM, Rhys A.D. Stewart wrote: No it doesn't, I was hoping to create the file. Some testing here confirms it is saving file with postgres user permissions. I could get it to save by creating a directory owned by the postgres user in my home directory and saving to there. My

Re: [GENERAL] Access disk from plpython

2012-11-14 Thread Adrian Klaver
On 11/14/2012 09:03 AM, Jeff Janes wrote: On Wed, Nov 14, 2012 at 8:44 AM, Rhys A.D. Stewart 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,

Re: [GENERAL] Access disk from plpython

2012-11-14 Thread Jeff Janes
On Wed, Nov 14, 2012 at 8:44 AM, Rhys A.D. Stewart 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 "tru

Re: [GENERAL] Access disk from plpython

2012-11-14 Thread Adrian Klaver
On 11/14/2012 08:48 AM, Rhys A.D. Stewart wrote: This is it: ERROR: IOError: [Errno 13] Permission denied: '/root/p1/me.txt' CONTEXT: Traceback (most recent call last): PL/Python anonymous code block, line 3, in t = open('/root/p1/me.txt','w') PL/Python anonymous code block CCi

Re: [GENERAL] Access disk from plpython

2012-11-14 Thread Adrian Klaver
On 11/14/2012 08:44 AM, Rhys A.D. Stewart 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? What is the actual error message?

[GENERAL] Access disk from plpython

2012-11-14 Thread Rhys A.D. Stewart
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? Regards, Rhys