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
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 |