From: | "Ben-Nes Michael" <miki(at)canaan(dot)co(dot)il> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Unrecognized language Error |
Date: | 2002-01-23 18:32:39 |
Message-ID: | 001401c1a43c$566d9620$aa0f5ac2@canaan.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
--------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-01-23 18:40:43 | Canadian website mirror |
Previous Message | Tom Pfau | 2002-01-23 18:02:04 | Re: pad column with leading zeros or space |