Re: BUG #1259: garbage in pg_listener after backend crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Vadim Passynkov" <Vadim(dot)Passynkov(at)pathcom(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1259: garbage in pg_listener after backend crash
Date: 2004-09-19 16:34:37
Message-ID: 19527.1095611677@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> writes:
> If current backend crash after registers on the notification condition
> <name> ( 'LISTEN <name>' SQL command ) row in the pg_listener still exists;

This is not a bug, it's the intended recovery path. The row will go
away as soon as some other backend tries to signal it and finds the
PID no longer exists.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-09-19 19:29:28 Re: Money type not gone?
Previous Message PostgreSQL Bugs List 2004-09-19 15:39:31 BUG #1259: garbage in pg_listener after backend crash