Обсуждение: Unrecognized language Error

Поиск

Список

Период

Сортировка

Unrecognized language Error

От

"Ben-Nes Michael"

Дата:

23 января 2002 г., 13: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

От

Jan Wieck

Дата:

23 января 2002 г., 14: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

От

Stephan Szabo

Дата:

23 января 2002 г., 14: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

От

Bruce Momjian

Дата:

23 января 2002 г., 14: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

От

Darren Ferguson

Дата:

23 января 2002 г., 14: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

От

Bruce Momjian

Дата:

23 января 2002 г., 15: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

От

Jan Wieck

Дата:

23 января 2002 г., 15: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

От

"Ben-Nes Michael"

Дата:

24 января 2002 г., 03: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.
>
>

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Unrecognized language Error