Thread: Create Function... ERROR: language "plpgsql" does not exist

Create Function... ERROR: language "plpgsql" does not exist

From

"Thomas LeBlanc"

Date:

13 October 2003, 18:52:23

I copied an example from the help:

CREATE FUNCTION somefunc() RETURNS integer AS '
DECLARE
    quantity integer := 30;
BEGIN
    RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 30
    quantity := 50;
    --
    -- Create a subblock
    --
    DECLARE
        quantity integer := 80;
    BEGIN
        RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is
80
    END;

    RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 50

    RETURN quantity;
END;
' LANGUAGE plpgsql


Ran it is a SQL window from pgAdmin and got this error:

ERROR:  language "plpgsql" does not exist

Thanks,
Thomas LeBlanc

_________________________________________________________________
Share your photos without swamping your Inbox.  Get Hotmail Extra Storage
today! http://join.msn.com/?PAGE=features/es

Re: Create Function... ERROR: language "plpgsql" does

From

darren@crystalballinc.com

Date:

13 October 2003, 18:57:45

You do not have the language installed in the database.

use the createlang function in the bin directory and create the langiage
for the data base i.e.

createlang -d dbname plpgsql

HTH
Darren

On Mon, 13 Oct 2003, Thomas LeBlanc wrote:

> I copied an example from the help:
>
> CREATE FUNCTION somefunc() RETURNS integer AS '
> DECLARE
>     quantity integer := 30;
> BEGIN
>     RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 30
>     quantity := 50;
>     --
>     -- Create a subblock
>     --
>     DECLARE
>         quantity integer := 80;
>     BEGIN
>         RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is
> 80
>     END;
>
>     RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 50
>
>     RETURN quantity;
> END;
> ' LANGUAGE plpgsql
>
>
> Ran it is a SQL window from pgAdmin and got this error:
>
> ERROR:  language "plpgsql" does not exist
>
> Thanks,
> Thomas LeBlanc
>
> _________________________________________________________________
> Share your photos without swamping your Inbox.  Get Hotmail Extra Storage
> today! http://join.msn.com/?PAGE=features/es
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
Darren Ferguson

Re: Create Function... ERROR: language "plpgsql" does

From

Renê Salomão

Date:

14 October 2003, 12:38:33

Hi Thomas,

 Did you create/insert plpgsql language in your database? I guess not...

 Check your database with createlang -l YOUR_DATABASE_NAME. This should
show you the languages installed in your database. In case you don't
have it, just use createlang plplgsql YOUR_DATABASE_NAME. This should
work...
 Suggestion, if you are gonna use plpgsql a lot developing in
Postgresql, I suggest that you create the language you need in template1
(createlang LANGUAGE template1). By doing that you will automatically
create the language in your new database when issuing a createdb
NEWDATABASE, because createdb uses template1 as a template to create
your new database...

RTM createlang for more info...

On Mon, 13 Oct 2003 10:58:55 -0500
"Thomas LeBlanc" <thomasatiem@hotmail.com> wrote:

> I copied an example from the help:
>
> CREATE FUNCTION somefunc() RETURNS integer AS '
> DECLARE
>     quantity integer := 30;
> BEGIN
>     RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here
>     is 30 quantity := 50;
>     --
>     -- Create a subblock
>     --
>     DECLARE
>         quantity integer := 80;
>     BEGIN
>         RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity
>         here is
> 80
>     END;
>
>     RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here
>     is 50
>
>     RETURN quantity;
> END;
> ' LANGUAGE plpgsql
>
>
> Ran it is a SQL window from pgAdmin and got this error:
>
> ERROR:  language "plpgsql" does not exist
>
> Thanks,
> Thomas LeBlanc
>
> _________________________________________________________________
> Share your photos without swamping your Inbox.  Get Hotmail Extra
> Storage today! http://join.msn.com/?PAGE=features/es
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 1: subscribe and unsubscribe
> commands go to majordomo@postgresql.org
>

-----------------------------

Cordialmente,

Renê Salomão
rene@ibiz.com.br
rene.salomao@interchange.com.br

--------------------------------

Re: Create Function... ERROR: language "plpgsql" does not exist

From

chet@crashed.net (Chet Luther)

Date:

15 October 2003, 14:24:16

You need to create the plpgsql language in your database first.  See
http://www.faqs.org/docs/ppbook/c19610.htm for how to do this.

Hope this helps,
chet@crashed.net

thomasatiem@hotmail.com ("Thomas LeBlanc") wrote in message news:<Law9-F78SH3ZIrqTIov0000f92d@hotmail.com>...
> I copied an example from the help:
>
> CREATE FUNCTION somefunc() RETURNS integer AS '
> DECLARE
>     quantity integer := 30;
> BEGIN
>     RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 30
>     quantity := 50;
>     --
>     -- Create a subblock
>     --
>     DECLARE
>         quantity integer := 80;
>     BEGIN
>         RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is
> 80
>     END;
>
>     RAISE NOTICE ''Quantity here is %'', quantity;  -- Quantity here is 50
>
>     RETURN quantity;
> END;
> ' LANGUAGE plpgsql
>
>
> Ran it is a SQL window from pgAdmin and got this error:
>
> ERROR:  language "plpgsql" does not exist
>
> Thanks,
> Thomas LeBlanc