Re: Unrecognized language Error

Ben-Nes Michael wrote:
[Charset windows-1255 unsupported, skipping...]

    ^^^^ First major mistake!!!!

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

                                ^^^^^^^^

    What about a little nap? Catching some sleep every other day
    helps ... sometimes :-)


Jan

> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgpsql'.
>         Recognized languages are sql, C, internal, and created procedural
> languages.
> comp.canaan.co.il=#



--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com