Thread: Unrecognized language Error

Unrecognized language Error

From

"Ben-Nes Michael"

Date:

23 January 2002, 16:45:39

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

Re: Unrecognized language Error

From

Jan Wieck

Date:

23 January 2002, 17:03:05

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

Re: Unrecognized language Error

From

Stephan Szabo

Date:

23 January 2002, 17:13:03

On Wed, 23 Jan 2002, Ben-Nes Michael wrote:

> 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';
You meant 'plpgsql' right? ;)

> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgpsql'.
>         Recognized languages are sql, C, internal, and created procedural
> languages.

Re: Unrecognized language Error

From

Bruce Momjian

Date:

23 January 2002, 17:13:04

> > 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 :-)

Isn't that our PGP-encrypted stored procedure language?  You mean you
didn't write that one yet, Jan.  :-)

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Unrecognized language Error

From

Darren Ferguson

Date:

23 January 2002, 17:42:48

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@postgresql.org so that your
> message can get through to the mailing list cleanly
>

Re: Unrecognized language Error

From

Bruce Momjian

Date:

23 January 2002, 18:34:01

>     Plpgpdfql  for  example   would   be   very   efficient   for
>     personalized  mass  emailing.  The  current  practice of HTML
>     spamming doesn't fill the available bandwidth ...

I can see it now, "PostgreSQL, the choice of spammers worldwide."

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Re: Unrecognized language Error

From

Jan Wieck

Date:

23 January 2002, 18:42:54

Bruce Momjian wrote:
> > > 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 :-)
>
> Isn't that our PGP-encrypted stored procedure language?  You mean you
> didn't write that one yet, Jan.  :-)

    Of course NOT! That name was reserved for the embedded

    "PostScript Query Language" (psql)

    But  it'll  be  more  like  a  datatype to store documents as
    PostScript templates, that on retrieval fill  in  the  actual
    data into variable fields in the document.

    Slight  variants  of  it  will  be  plpgpdfql, plpgpcl5ql and
    plpghpglql.

    Plpgpdfql  for  example   would   be   very   efficient   for
    personalized  mass  emailing.  The  current  practice of HTML
    spamming doesn't fill the available bandwidth ...


Jan

--

#======================================================================#
# 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

Re: Unrecognized language Error

From

"Ben-Nes Michael"

Date:

24 January 2002, 06:13:22

oops :)
To much work hour
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--------------------------

----- Original Message -----
From: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>
To: "Ben-Nes Michael" <miki@canaan.co.il>
Cc: <pgsql-general@postgresql.org>
Sent: Wednesday, January 23, 2002 8:57 PM
Subject: Re: [GENERAL] Unrecognized language Error


>
> On Wed, 23 Jan 2002, Ben-Nes Michael wrote:
>
> > 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';
> You meant 'plpgsql' right? ;)
>
> > ERROR:  Unrecognized language specified in a CREATE FUNCTION:
'plpgpsql'.
> >         Recognized languages are sql, C, internal, and created
procedural
> > languages.
>
>