ALTER LANGUAGE?

From: PeterKorman <calvin-pgsql-ml(at)eigenvision(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ALTER LANGUAGE?
Date: 2003-05-24 01:19:31
Message-ID: 20030524011931.GA6155@eigenvision.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-05-24 01:53:24 Re: Building 7.3.2 on HP-UX w/out zlib/readline
Previous Message Erik Ronström 2003-05-24 01:09:48 Error parsing