language "plpgsql" does not exist

From: Bruce Young <hbrucey(at)yahoo(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: language "plpgsql" does not exist
Date: 2003-05-23 06:48:31
Message-ID: 20030523064831.64448.qmail@web10403.mail.yahoo.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Oleg Bartunov 2003-05-23 06:55:42 Re: Can arrays reference primary keys in CREATE TABLE?
Previous Message Alexey Dashevsky 2003-05-23 05:51:49 Re: numeric fields and null