Re: LISTEN/NOTIFY enhancement: Portable signal handling?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sean Chittenden <sean@chittenden.org>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2004-12-27T17:04:35Z
Lists: pgsql-hackers
Sean Chittenden <sean@chittenden.org> writes: > * Allow LISTEN to block until a value changes. LISTEN [BLOCK|WAIT] > 'relname' > * Allow LISTEN to have a timeout > LISTEN name [BLOCK] [WITH] [TIMEOUT [=] ''::INTERVAL]; > * Allow blocking LISTEN queries to update the status of the proc title > while blocking. I don't believe in any of these things, at least not on the server side. You can get the same effect on the client side without cluttering the LISTEN semantics and implementation. regards, tom lane