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 по дате отправления: