PL/pgSQL - Mailing list pgsql-general

From Sergei Chernev
Subject PL/pgSQL
Date
Msg-id 000001be0d75$897e19b0$59d17cc1@ser.cnit.nsu.ru
Whole thread Raw
Responses Re: [GENERAL] PL/pgSQL  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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 by date:

Previous
From: Dustin Sallings
Date:
Subject: Re: [GENERAL] Does 6.4 work with Irix 6.5.1 ?
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] rollback question...