Port Bug Report: calling notify in pl/pgsql proc causes core dump

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

--------------------------------------------------------------------------