Re: Unrecognized language Error
От | Jan Wieck |
---|---|
Тема | Re: Unrecognized language Error |
Дата | |
Msg-id | 200201231901.g0NJ14q15466@saturn.janwieck.net обсуждение исходный текст |
Ответ на | Unrecognized language Error ("Ben-Nes Michael" <miki@canaan.co.il>) |
Ответы |
Re: Unrecognized language Error
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: