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