PL/pgSQL
От | Sergei Chernev |
---|---|
Тема | PL/pgSQL |
Дата | |
Msg-id | 000001be0d75$897e19b0$59d17cc1@ser.cnit.nsu.ru обсуждение исходный текст |
Ответы |
Re: [GENERAL] PL/pgSQL
|
Список | pgsql-general |
Hello, I've installed postgresql-v6.4 on BSDI-3.1 But, there are two problems with PL/pgSQL: First: I have to install plpgsql language on every database, I wonder, if I can install it for everyone. Second: When I install plpgsql language, and prepare one test: =>CREATE FUNCTION f_test () RETURNS abstime AS ' => BEGIN => RETURN \'now\'; => END; =>' LANGUAGE 'plpgsql'; CREATE EOF Then I do: => select f_test(); It tells me, that: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while pr ocessing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. and exit me to the shell. What is wrong ? Thank you, --------------------------- Sergei Chernev Internet: ser@nsu.ru Phone: +7-3832-397354
В списке pgsql-general по дате отправления: