PL/pgSQL

Поиск
Список
Период
Сортировка
От Sergei Chernev
Тема PL/pgSQL
Дата
Msg-id 000001be0d75$897e19b0$59d17cc1@ser.cnit.nsu.ru
обсуждение исходный текст
Ответы Re: [GENERAL] PL/pgSQL  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Dustin Sallings
Дата:
Сообщение: Re: [GENERAL] Does 6.4 work with Irix 6.5.1 ?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] rollback question...