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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026