Joe, all:
Ok, this is wierd. This is PostgreSQL 9.2.4, on Centos 6, installed
using the packages at yum.postgresql.org. Is the below an issue with
PL/R, the packages, or PostgreSQL?
Seems like if a language is actually *installed*, it needs to have
templates ...
analytics=# \dL
List of languages
Name | Owner | Trusted | Description
-----------+----------+---------+------------------------------------------
plpgsql | postgres | t | PL/pgSQL procedural language
plpythonu | postgres | f | PL/PythonU untrusted procedural language
plr | postgres | f |
analytics=# select * from pg_pltemplate ;
tmplname | tmpltrusted | tmpldbacreate | tmplhandler |
tmplinline | tmplvalidator | tmpllibrary | tmp
lacl
------------+-------------+---------------+------------------------+--------------------------+---------------------+-------------------+----
-----
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 | plperlu_call_handler |
plperlu_inline_handler | plperlu_validator | $libdir/plperl |
plpythonu | f | f | plpython_call_handler |
plpython_inline_handler | plpython_validator | $libdir/plpython2 |
plpython2u | f | f | plpython2_call_handler |
plpython2_inline_handler | plpython2_validator | $libdir/plpython2 |
plpython3u | f | f | plpython3_call_handler |
plpython3_inline_handler | plpython3_validator | $libdir/plpython3 |
(8 rows)
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
