Re: Problem with PL/pgSQL
От | Mitch Vincent |
---|---|
Тема | Re: Problem with PL/pgSQL |
Дата | |
Msg-id | 003f01c09edd$b185f080$0200000a@windows обсуждение исходный текст |
Ответ на | Problem with PL/pgSQL (Hans-Jürgen Schönig <hs@cybertec.at>) |
Список | pgsql-general |
You need to do CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS '/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C'; And : CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER plpgsql_call_handler LANCOMPILER 'PL/pgSQL'; ----- Original Message ----- From: "Hans-Jürgen Schönig" <hs@cybertec.at> To: <pgsql-general@postgresql.org> Sent: Saturday, February 24, 2001 10:01 AM Subject: Problem with PL/pgSQL > What is wrong with the following function? > > CREATE FUNCTION logfunc2 (text) RETURNS int AS ' > DECLARE > text ALIAS FOR $1; > BEGIN > SELECT length(text); > RETURN ''3''; > END; > ' LANGUAGE 'plpgsql'; > > I get the following error: > > ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. > > Recognized languages are sql, C, internal, and created > procedural languages. > > > According to my docs "plpgsql" should be ok. > > Hans > >
В списке pgsql-general по дате отправления: