Re: LISTEN filtering - Mailing list pgsql-general

From Merlin Moncure
Subject Re: LISTEN filtering
Date
Msg-id BANLkTimRDKjBNsova_eFo=fe4AXic03yNQ@mail.gmail.com
Whole thread Raw
In response to LISTEN filtering  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: LISTEN filtering
List pgsql-general
On Tue, Jun 21, 2011 at 10:58 AM, Greg Sabino Mullane <greg@turnstep.com> wrote:
> Quick idea to toss out there: allowing an option to LISTEN to
> only 'hear' from superusers (or self). I've got an app that uses a lot
> of listen/notify to talk to other subprocesses. However, it
> would be nice if non-superusers could not affect the behavior
> of this application: right now, anyone can issue a NOTIFY. (Yes,
> I can look information up about the calling notifier's PID,
> but that's not easy). Rather than a full 'rights' system (which
> would be complex overkill), what if we had an  option to LISTEN
> that said "I only want to hear notices coming from superusers"?
> Or perhaps an option that says "I only want to hear notices
> coming from me (same role)"? This would not affect notifications
> at all, but would simply act as a quick filter on incoming
> notices for a specific listener.

hm.  maybe you could use the 9.1 payload feature so that your custom
behavior would only be invoked if a particular payload was sent?

merlin

pgsql-general by date:

Previous
From: Cédric Villemain
Date:
Subject: Re: PostgreSQL 8.4.8 bringing my website down every evening
Next
From: Sylvain Rabot
Date:
Subject: Re: Partitioning and constraint exclusion