I have:

---------------------------------------------------------------------

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)

---------------------------------------------------------------------

I wanna do this:


---------------------------------------------------------------------
UPDATE pg_language SET lanpltrusted=true WHERE lanname='plpgsql';
---------------------------------------------------------------------

Is this gonna break anything? That is, are there dependencies
in this table that I will break or otherwise compromise if I 
perform the above sql update. Does the effect of:

'CREATE TRUSTED LANGUAGE'

differ from: 

'CREATE LANGUAGE', 


some way other than setting true, the 'lanpltrusted' column of 
the 'plpgsql' row, of the 'pg_language' table?

I understand that my other option is to delete the language 
and then add it create it
again with:


---------------------------------------------------------------------
drop language 'plpgsql';
drop function 'plpgsql_call_handler';

CREATE FUNCTION plpgsql_call_handler ()
                RETURNS OPAQUE
                AS '/usr/lib/postgresql/plpgsql.so'
                LANGUAGE 'C';

CREATE TRUSTED LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler
                LANCOMPILER 'PL/pgSQL';
---------------------------------------------------------------------

Thanks.
Cheers,


JPK


Sat, 24 May 2003 11:58:59 -0400
PeterKorman <calvin-pgsql-ml@eigenvision.com>
UPDATE pg_language SET lanpltrusted=true WHERE lanname='plpgsql'
PeterKorman <calvin-pgsql-ml@eigenvision.com> writes:
> I wanna do this:
> UPDATE pg_language SET lanpltrusted=true WHERE lanname='plpgsql';

Should be okay.  Next time, create your languages with the createlang
script ...

			regards, tom lane

Sat, 24 May 2003 22:57:35 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: UPDATE pg_language SET lanpltrusted=true WHERE lanname='plpgsql' 