Thread: Backend crashes with notification rule

Backend crashes with notification rule

From
Bernd Helmle
Date:
I have this on 8.0dev (checked out last friday):

yomama=# SELECT version();                                 version
---------------------------------------------------------------------------PostgreSQL 8.0devel on i686-pc-linux-gnu,
compiledby 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
oderwä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


Re: Backend crashes with notification rule

From
Tom Lane
Date:
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