Skip site navigation (1) Skip section navigation (2)

Re: LISTEN/NOTIFY enhancement: Portable signal handling?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sean Chittenden <sean(at)chittenden(dot)org>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: LISTEN/NOTIFY enhancement: Portable signal handling?
Date: 2004-12-27 17:04:35
Message-ID: 7028.1104167075@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Sean Chittenden <sean(at)chittenden(dot)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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-12-27 17:41:07
Subject: Re: LISTEN/NOTIFY enhancement: Portable signal handling?
Previous:From: Adrian MaierDate: 2004-12-27 10:55:06
Subject: Re: Help Needed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group