Port Bug Report: calling notify in pl/pgsql proc causes core dump - Mailing list pgsql-ports

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


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