Re: [GENERAL] PL/pgSQL

[Charset koi8-r unsupported, filtering to ASCII...]
> 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.

If you put it in template1, then every new database gets it.

>
> 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 ?

It shouldn't be doing this, but it is.  Something wrong about the way
bsdi 3.* is doing dynamic linking, I think.  bsdi 4.0, which I have here
works.

Can you do it in gdb and send the backtrace of the crash?

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026