Re: [PORTS] Port Bug Report: calling notify in pl/pgsql proc causes core dump

Jan, this is yours.


>
> ============================================================================
>                         POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
>
> Your name               : David Mansfield
> Your email address      : david@cobite.com
>
> Category                : runtime: back-end
> Severity                : serious
>
> Summary: calling notify in pl/pgsql proc causes core dump
>
> System Configuration
> --------------------
>   Operating System   : Linux 2.2.9
>
>   PostgreSQL version : 6.5
>
>   Compiler used      : gcc 2.7.2.3
>
> Hardware:
> ---------
> RedHat 5.2
>
> Versions of other tools:
> ------------------------
> RedHat 5.2 standard
>
> --------------------------------------------------------------------------
>
> Problem Description:
> --------------------
> calling notify in pl/pgsql proc causes core dump
>
> --------------------------------------------------------------------------
>
> Test Case:
> ----------
> createdb bugs
> psql bugs
> \i /usr/src/postgresql-6.5/src/pl/plpgsql/src/mklang.sql
> create  function a_func()
>         returns
>                 char
>         as
>                 'begin
>                        notify my_listen;
>                        return \'a\';
>                  end;'
>         language
>                 'plpgsql'
> ;
> select a_func();
>
>
> --------------------------------------------------------------------------
>
> Solution:
> ---------
>
>
> --------------------------------------------------------------------------
>
>
>


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