From: | Korin Richmond <korin(at)cstr(dot)ed(dot)ac(dot)uk> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: plpythonu and PYTHONPATH/sys.path |
Date: | 2007-03-06 14:40:53 |
Message-ID: | Pine.LNX.4.64.0703061430470.12804@tarrant.cstr.ed.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 6 Mar 2007, Richard Huxton wrote:
> Korin Richmond wrote:
>> Hi,
>>
>> I want to use python modules I have written in plpythonu. I can load these
>> modules in functions within postgres if they are installed in the
>> "official" python module directories (e.g. /blah/site-packages etc.)
>>
>> However, I want to use modules which are in my home file space, but I can't
>> get this to work.
>
> Does user "postgres" have access to your home directory?
Sorry, yes, I forgot to mention I've checked it's not just a permissions problem
by putting the module in /tmp, readable by everyone, and appending "/tmp" to
sys.path in the function in the database. Still complains that the module can't
be found though :(
(If I fire up python as user postgres, I can import the module from /tmp.)
Korin
--
=====================================================================
Dr. Korin Richmond Centre for Speech Technology Research
2 Buccleuch Pl, Edinburgh, EH8 9LW
Tel: +44 (0)131 651 1769
http://www.cstr.ed.ac.uk/ssi/people/korin.html
=====================================================================
From | Date | Subject | |
---|---|---|---|
Next Message | Andy | 2007-03-06 14:41:26 | Re: Importing *huge* mysql database into pgsql |
Previous Message | Webb Sprague | 2007-03-06 14:39:11 | Re: Importing *huge* mysql database into pgsql |