ALTER LANGUAGE?
От | PeterKorman |
---|---|
Тема | ALTER LANGUAGE? |
Дата | |
Msg-id | 20030524011931.GA6155@eigenvision.com обсуждение исходный текст |
Список | 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
Вложения
В списке pgsql-general по дате отправления: