I have this on 8.0dev (checked out last friday):

yomama=# SELECT version();
                                  version
---------------------------------------------------------------------------
 PostgreSQL 8.0devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.0
(1 Zeile)

yomama=# CREATE TABLE test (test text);
CREATE TABLE

yomama=# CREATE RULE rule_insert_test AS ON INSERT TO test DO NOTIFY 
test_notification;
CREATE RULE

yomama=# INSERT INTO test VALUES ('test');
Server beendete die Verbindung unerwartet
        Das heißt wahrscheinlich, daß der Server abnormal beendete
        bevor oder während die Anweisung bearbeitet wurde.
Die Verbindung zum Server wurde verloren.  Versuche Reset: Fehlgeschlagen.
!>

With assert check enabled, i got this in the logfile:

TRAP: FailedAssertion("!(n < list->length)", File: "list.c", Line: 392)
LOG:  server process (PID 18637) was terminated by signal 6
LOG:  terminating any other active server processes

Sorry for the german locale .....

-- 
  Bernd

Sat, 07 Aug 2004 17:34:54 +0200
Bernd Helmle <mailings@oopsware.de>
Backend crashes with notification rule
Bernd Helmle <mailings@oopsware.de> writes:
> I have this on 8.0dev (checked out last friday):
> yomama=# CREATE RULE rule_insert_test AS ON INSERT TO test DO NOTIFY 
> test_notification;
> [ causes crash ]

Fixed.  Thanks for the report!

			regards, tom lane

Sat, 07 Aug 2004 13:41:40 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: Backend crashes with notification rule 