I have:
==========================================================================
template1=# \l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
manifest | manifest | SQL_ASCII
postgres | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
(4 rows)
template1=# \d pg_language
Table "pg_language"
Column | Type | Modifiers
---------------+---------+-----------
lanname | name |
lanispl | boolean |
lanpltrusted | boolean |
lanplcallfoid | oid |
lancompiler | text |
Unique keys: pg_language_name_index,
pg_language_oid_index
template1=# select * from pg_language;
lanname | lanispl | lanpltrusted | lanplcallfoid | lancompiler
----------+---------+--------------+---------------+-------------
internal | f | f | 0 | n/a
C | f | f | 0 | /bin/cc
sql | f | f | 0 | postgres
plpgsql | t | f | 16709 | PL/pgSQL
(4 rows)
==========================================================================
Is this gonna break anything? Thanks.
UPDATE pg_language
SET lanpltrusted=true
where lanname='plpgsql';
Cheers,
JPK
