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.Elphick@lfix.co.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