Re: plpythonu and PYTHONPATH/sys.path

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
=====================================================================