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

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(at)postgresql(dot)org
>

--
Darren Ferguson