RE: [GENERAL] PL/pgSQL - Mailing list pgsql-general

From Sergei Chernev
Subject RE: [GENERAL] PL/pgSQL
Date
Msg-id 000001be0ef9$ce06a4a0$59d17cc1@ser.cnit.nsu.ru
Whole thread Raw
In response to Re: [GENERAL] PL/pgSQL  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [GENERAL] PL/pgSQL
List pgsql-general
> In 6.4, it should work on all platforms.  I know it works on bsdi 4.0.
Hello,
>
> What problems are you seeing.

I still have 3.1 :((

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 processing the request.
We have lost the connection to the backend, so further processing is
impossible.
  Terminating.

After that, another programms, which was connected to postgres, loose
connection.
Regression test falls on PL/pgSQL.


With best wishes,
---------------------------
Sergei Chernev
Internet: ser@nsu.ru
Phone: +7-3832-397354


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)
Next
From: Jeroen Schaap
Date:
Subject: Re: [GENERAL] Failing lo_import on RH 5.1 -- postgresql-6.3.2 (please help-I'm on my knees..)