language "plpgsql" does not exist

Поиск
Список
Период
Сортировка
От Bruce Young
Тема language "plpgsql" does not exist
Дата
Msg-id 20030523064831.64448.qmail@web10403.mail.yahoo.com
обсуждение исходный текст
Ответы 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>)
Список 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
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 по дате отправления:

Предыдущее
От: Rod Taylor
Дата:
Сообщение: Re: plpgsql recursion
Следующее
От: Alexey Dashevsky
Дата:
Сообщение: Re: numeric fields and null