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
