On Tue, Jun 21, 2011 at 10:58 AM, Greg Sabino Mullane <greg@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
