Re: plperl db crash

On Thu, 2003-10-02 at 18:30, Nabil Sayegh wrote:
> I had a db lock up on one of our machines.
> To reproduce it, I did a fresh install on a testing machine.
...
> ------------------------------------------------------------------------
> debian/unstable
> postgresql 7.3.4
>
> /usr/lib/postgresql/bin/createlang plperl plasma
> psql plasma
>
> CREATE FUNCTION perlsub(text, text, text) RETURNS text AS '
> my ($data, $pat, $repl) = $_;
^^^
That should be @_ (but that wouldn't cause the crash).

> $data =~ s/$pat/$repl/;
> return $data
> ' LANGUAGE 'plperl';
>
> -- Taken from here:
> -- http://archives.postgresql.org/pgsql-general/2001-02/msg00798.php
>
> plasma=# SELECT perlsub('abc','b','123');
> server closed the connection unexpectedly

I'm just uploading 7.3.4-6 to unstable.

I've tested this function with that release and your problem does not
occur on my system, but I'm not aware of having done anything to affect
it.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"I beseech you therefore, brethren, by the mercies of
God, that ye present your bodies a living sacrifice,
holy, acceptable unto God, which is your reasonable
service. And be not conformed to this world; but be ye
transformed by the renewing of your mind, that ye may
prove what is that good, and acceptable, and perfect,
will of God." Romans 12:1,2