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
