Thread: ALTER LANGUAGE?

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