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 language in 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(at)yahoo(dot)com]
Sent: Friday, 23 May 2003 16:49
To: pgsql-sql(at)postgresql(dot)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 INTO logtable 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(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly