Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #1259: garbage in pg_listener after backend crash - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1259: garbage in pg_listener after backend crash
Date
Msg-id 19527.1095611677@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1259: garbage in pg_listener after backend crash  ("PostgreSQL Bugs List" <pgsql-bugs@postgresql.org>)
List pgsql-bugs
Tree view 
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.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

pgsql-bugs by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1259: garbage in pg_listener after backend crash
Next
From: Josh Berkus
Date:
Subject: Money type not gone?