how to install plpython?

Started by AI Rummanalmost 15 years ago6 messagesgeneral
Jump to latest
#1AI Rumman
rummandba@gmail.com

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?

#2Craig Ringer
craig@2ndquadrant.com
In reply to: AI Rumman (#1)
Re: how to install plpython?

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

#3AI Rumman
rummandba@gmail.com
In reply to: Craig Ringer (#2)
Re: how to install plpython?

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:

Show quoted text

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

#4Sim Zacks
sim@compulab.co.il
In reply to: AI Rumman (#3)
Re: how to install plpython?

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

Sim

Show quoted text

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 <mailto: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

#5Craig Ringer
craig@2ndquadrant.com
In reply to: AI Rumman (#3)
Re: how to install plpython?

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

#6Adrian Klaver
adrian.klaver@aklaver.com
In reply to: AI Rumman (#3)
Re: how to install plpython?

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