| 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: | Whole Thread | Raw Message | 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 |