From: | Darren Ferguson <darren(at)crystalballinc(dot)com> |
---|---|
To: | Ben-Nes Michael <miki(at)canaan(dot)co(dot)il> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Unrecognized language Error |
Date: | 2002-01-23 19:32:43 |
Message-ID: | Pine.LNX.4.10.10201231432010.23268-100000@thread.crystalballinc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
The language should be plpgsql not plpgpsql
Darren
On Wed, 23 Jan 2002, Ben-Nes Michael wrote:
> 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
> --------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Vivek Khera | 2002-01-23 19:42:26 | Re: postgresql 7.2b5 and vserver: statistics sockets |
Previous Message | Tom Lane | 2002-01-23 19:16:57 | Re: postgresql 7.2b5 and vserver: statistics sockets |