Re: language "plpgsql" does not exist

createlang plpgsql <db>

On Tue, 2 Sep 2003, Sebastien Baudry wrote:

> Hi everybody.
> I'm a new born in the PostGreSQL domain (usually deal with Oracle or SQL
> Server) and I got the following error when trying to create a function using
> the default language plpgsql: language "plpgsql" does not exist
> I was not able to find clues on the net to help me to solve this problem,
> that's why I'm sending this post now.
>
> I just installed the version 7.3.4 of PostGreSQL (basic installation).
>
> Here the source of the function I try to create:
> -------------
> CREATE OR REPLACE FUNCTION ts_groupEdit
> (VARCHAR,INTEGER,VARCHAR,VARCHAR,INTEGER,INTEGER) RETURNS INTEGER AS '
>
> DECLARE
> vi_name ALIAS FOR $1;
> vi_companyId ALIAS FOR $2;
> vi_description ALIAS FOR $3;
> vi_rights ALIAS FOR $4;
> vi_debug ALIAS FOR $5;
> v_groupId INTEGER;
> BEGIN
> SELECT groupId INTO v_groupId
> FROM Groups
> WHERE companyId=vi_companyid AND
> name=vi_name;
>
> IF v_groupId IS NOT NULL THEN
> UPDATE GROUPS SET description=vi_description
> WHERE groupId=v_groupId;
> ELSE
> INSERT INTO Groups (companyId, name, description)
> VALUES (vi_companyid, vi_name, vi_description);
> END IF;
>
> RETURN 0;
> END; '
> LANGUAGE 'plpgsql';
> -------------
>
>
> Any help will be welcome.
> May be I have to load or install the plpgsql module, but I didn't find such
> instruction in the documentation so I guess it is there by default.
>
> Seb.
>
> --
> Sébastien BAUDRY - DBA Oracle/MS-SQL & Project Manager
> BAUDRY ENGINEERING BT. H-1025 Budapest Verhalom utca. 31/D. I/8.
> @.: sebastien(dot)baudry(at)baudry-engineering(dot)com
> mobile.: +36-30-392-0279 / tel: +36-1-326-0241 / fax: +36-1-326-0241
> http://www.baudry-engineering.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>