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(at)cobite(dot)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(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