Thread: how to install plpython?

Hi guys,

I need to install plpython language in my db.

testdb=# create language plpythonu;
ERROR:  could not access file "$libdir/plpython": No such file or directory

-bash-3.2$ pwd
/usr/pgsql-9.0/lib
-bash-3.2$ ls pl*
plpgsql.so

testdb=# select * from pg_pltemplate;
  tmplname  | tmpltrusted | tmpldbacreate |      tmplhandler       |        tmplinline        |   tmplvalidator   |    tmpllibrary    | tmplacl
------------+-------------+---------------+------------------------+--------------------------+-------------------+-------------------+---------
 plpgsql    | t           | t             | plpgsql_call_handler   | plpgsql_inline_handler   | plpgsql_validator | $libdir/plpgsql   |
 pltcl      | t           | t             | pltcl_call_handler     |                          |                   | $libdir/pltcl     |
 pltclu     | f           | f             | pltclu_call_handler    |                          |                   | $libdir/pltcl     |
 plperl     | t           | t             | plperl_call_handler    | plperl_inline_handler    | plperl_validator  | $libdir/plperl    |
 plperlu    | f           | f             | plperl_call_handler    | plperl_inline_handler    | plperl_validator  | $libdir/plperl    |
 plpythonu  | f           | f             | plpython_call_handler  | plpython_inline_handler  |                   | $libdir/plpython  |
 plpython2u | f           | f             | plpython_call_handler  | plpython_inline_handler  |                   | $libdir/plpython2 |
 plpython3u | f           | f             | plpython3_call_handler | plpython3_inline_handler |                   | $libdir/plpython3 |
(8 rows)


Where may I get plpython.so?

On 14/06/11 15:33, AI Rumman wrote:
> Hi guys,
>
> I need to install plpython language in my db.

How did you install Pg?

See: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Craig Ringer

Okay. Thanks for the guidance.
Could you please tell where I can get the postgresql-python lib files?

What OS/distribution are you using?
If you compiled postgresql your self did you include python support?

Sim

On 06/14/2011 12:17 PM, AI Rumman wrote:

Okay. Thanks for the guidance.
Could you please tell where I can get the postgresql-python lib files?

On Tue, Jun 14, 2011 at 2:01 PM, Craig Ringer <craig@postnewspapers.com.au> wrote:

On 14/06/11 15:33, AI Rumman wrote:
> Hi guys,
>
> I need to install plpython language in my db.

How did you install Pg?

See: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems

--
Craig Ringer

On 06/14/2011 05:17 PM, AI Rumman wrote:
> Okay. Thanks for the guidance.
> Could you please tell where I can get the postgresql-python lib files?

Did you *read* the guidance in question?

You didn't even bother to answer the one simple question I asked. How do
you expect help if you don't supply enough information to allow anyone
to answer your question?

You didn't even mention what operating system you're on!

Please try *reading*
   http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
then try again.

[Yes, this email is a bit grumpy]

--
Craig Ringer

On Tuesday, June 14, 2011 2:17:32 am AI Rumman wrote:
> Okay. Thanks for the guidance.
> Could you please tell where I can get the postgresql-python lib files?
>

The short answer is it depends,  hence Craigs request for information on how it
was installed. The various packages handle it in different ways and if you are
configuring from source you have to specify that the files are built. With out
more information your question can not be answered.

> > Craig Ringer

--
Adrian Klaver
adrian.klaver@gmail.com