Home > mailing lists

language "plpgsql" does not exist - Mailing list pgsql-sql

From	Bruce Young
Subject	language "plpgsql" does not exist
Date	May 23, 2003 08:18:04
Msg-id	20030523064831.64448.qmail@web10403.mail.yahoo.com Whole thread Raw
Responses	Re: language "plpgsql" does not exist (Devrim GUNDUZ <devrim@gunduz.org>) Re: language "plpgsql" does not exist (Richard Huxton <dev@archonet.com>) Re: language "plpgsql" does not exist (Achilleus Mantzios <achill@matrix.gatewaynet.com>) Re: language "plpgsql" does not exist (Rod Taylor <rbt@rbt.ca>) Re: language "plpgsql" does not exist (Oliver Elphick <olly@lfix.co.uk>) Re: language "plpgsql" does not exist ("Victor Yegorov" <viktors.jegorovs@nordlb.lv>) Re: language "plpgsql" does not exist ("A.Bhuvaneswaran" <bhuvan@symonds.net>)
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: Rod Taylor
Date: 23 May 2003, 04:29:32
Subject: Re: plpgsql recursion

From: Alexey Dashevsky
Date: 23 May 2003, 08:21:33
Subject: Re: numeric fields and null

language "plpgsql" does not exist - Mailing list pgsql-sql

Previous

Next