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? ;)

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

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

The language should be plpgsql not plpgpsql

Darren

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

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

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

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