create language error in postgresql

Question

I tried to create a language pltcl in postgresql. But, I got this error.

postgres=# CREATE LANGUAGE 'pltcl';
ERROR:  could not access file "$libdir/pltcl": No such file or directory


postgres=# select * from pg_pltemplate;
 tmplname  | tmpltrusted | tmpldbacreate |      tmplhandler      |   tmplvalidator   |   tmpllibrary    | tmplacl 
-----------+-------------+---------------+-----------------------+-------------------+------------------+---------
 plpgsql   | t           | t             | plpgsql_call_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_validator  | $libdir/plperl   | 
 plperlu   | f           | f             | plperl_call_handler   | plperl_validator  | $libdir/plperl   | 
 plpythonu | f           | f             | plpython_call_handler |                   | $libdir/plpython |

After referred the internet, I got the answer. That is,

In order to get pltcl.so you will need to compile the postgres code using --with-tcl configure switch. pltcl does not compile by default with postgres.

How to fix this problem?

How did you install postgresql? From source?

thisfeller
– thisfeller

2012-10-27 12:40:43 +00:00
Commented Oct 27, 2012 at 12:40 — thisfeller
– thisfeller, Commented Oct 27, 2012 at 12:40

qqx · Accepted Answer · 2012-10-27 14:15:34Z

3

You need to install the postgresql-pltcl-9.1 package, replacing the 9.1 with the postgres version you're using if it's different.

answered Oct 27, 2012 at 14:15

qqx

19.6k5 gold badges67 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Erwin Brandstetter Over a year ago

Here you can find all PostgreSQL packages provided by Debian.

NobodyNada · Accepted Answer · 2018-03-16 06:28:42Z

2

sudo apt-get install postgresql-pltcl-9.6 postgresql-plperl-9.6

edited Mar 16, 2018 at 6:28

NobodyNada

7,6896 gold badges46 silver badges52 bronze badges

answered Mar 16, 2018 at 6:24

Vaibhav Bharadwaj

514 bronze badges

Collectives™ on Stack Overflow

create language error in postgresql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related