And if you do the below with template1 - It will be available in every database you create after that .
> You have to install the procedural language into each database as such: > > 1. su - postgres > 2. createlang plpgsql [your dbname here] ----- Original Message ----- From: "Renney Thomas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Admin Postgres" <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 3:12 AM Subject: Re: [ADMIN] language "plpgsql" does not exist > You have to install the procedural language into each database as such: > > 1. su - postgres > 2. createlang plpgsql [your dbname here] > > > > 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. > >@.: [EMAIL PROTECTED] > >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 > > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend > > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
