I am using PostgreSQL 9.3 beta 2
[postgres@lix Multicorn-master]$ psql
psql (9.3beta2)
Type "help" for help.
postgres=#
It does not work with ActivePython3.2(ActivePython-3.2.2.3-linux-x86_64.tar.gz), Which version of PostgreSQL are you running?
Regards,
Xiaobo Gu
------------------ Original ------------------
Sender: "Raghavendra"<raghavendra.rao@enterprisedb.com>;
Send time: Tuesday, Jul 9, 2013 8:00 PM
To: "guxiaobo1982"<guxiaobo1982@qq.com>;
Cc: "Jov"<amutu@amutu.com>; "Michael Paquier"<michael.paquier@gmail.com>; "pgsql-general"<pgsql-general@postgresql.org>;
Subject: Re: [GENERAL] 回复: [GENERAL] Can't create plpython language
[postgres@lix PostgreSQL]$ psql
Password:
psql (9.2.4)
Type "help" for help.
postgres=# create language plpython2u;
ERROR: could not access file "$libdir/plpython2": No such file or directory
postgres=# create language plpython3u;
ERROR: could not access file "$libdir/plpython3": No such file or directory
postgres=# \q
There are python 2.4.3 and python3.2 on the same machine,.
I tried to create it using ActivePython3.2. It worked.
Stop the running postgresql cluster and set the ActivePython3.2 path as below.
export PYTHONPATH=/opt/ActivePython-3.2/bin:$PATH
export PYTHONHOME=/opt/ActivePython-3.2/
export LD_LIBRARY_PATH=/opt/ActivePython-3.2/lib/
Now start the postgresql cluster and try creating the language;
-bash-4.1$ psql
psql.bin (9.2.3)
Type "help" for help.
postgres=# create language plpython3u;
CREATE LANGUAGE
postgres=#
---
Regards,
Raghavendra
EnterpriseDB Corporation
------------------ 原始邮件 ------------------
发送时间: 2013年7月5日(星期五) 上午7:59
主题: Re: [GENERAL] Can't create plpython language