Unrecognized language Error
От | Ben-Nes Michael |
---|---|
Тема | Unrecognized language Error |
Дата | |
Msg-id | 001401c1a43c$566d9620$aa0f5ac2@canaan.co.il обсуждение исходный текст |
Ответы |
Re: Unrecognized language Error
Re: Unrecognized language Error Re: Unrecognized language Error |
Список | pgsql-general |
Hi All I installed plpgsql with createlang but still I can use it. Here is a Snip: $ /usr/local/pgsql/bin/createlang -l -d comp.canaan.co.il Procedural languages Name | Trusted? | Compiler ---------+----------+---------- plpgsql | t | PL/pgSQL (1 row) comp.canaan.co.il=# CREATE FUNCTION addnumbers (INTEGER, INTEGER) RETURNS INTEGER AS ' comp.canaan.co.il'# DECLARE comp.canaan.co.il'# v1 ALIAS FOR $1; comp.canaan.co.il'# v2 ALIAS FOR $2; comp.canaan.co.il'# BEGIN comp.canaan.co.il'# RETURN v1 + v2; comp.canaan.co.il'# END;' comp.canaan.co.il-# LANGUAGE 'plpgpsql'; ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgpsql'. Recognized languages are sql, C, internal, and created procedural languages. comp.canaan.co.il=# -------------------------- Canaan Surfing Ltd. Internet Service Providers Ben-Nes Michael - Manager Tel: 972-4-6991122 http://sites.canaan.co.il --------------------------
В списке pgsql-general по дате отправления: