Re: language "plpgsql" does not exist

HI Bruce,

See the createlang shell script in the reference manual under the Client Applications section. You need to "create" a
languagein the target database before you can use it to program with against that database. 

Regards,
David Witham
Telephony Platforms Architect
Unidial

-----Original Message-----
From: Bruce Young [mailto:hbrucey@yahoo.com]
Sent: Friday, 23 May 2003 16:49
To: pgsql-sql@postgresql.org
Subject: [SQL] language "plpgsql" does not exist


i am trying to create functions only to get the above error in return.
what do i need to do to get PL/PGSQL functions working?
example:

CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '    DECLARE        logtxt ALIAS FOR $1;    BEGIN        INSERT
INTOlogtable VALUES (logtxt, ''now'');        RETURN ''now'';    END; 
' LANGUAGE plpgsql;

#  ERROR:  language "plpgsql" does not exist


any help appreciated


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly