LISTEN filtering

From: "Greg Sabino Mullane" <greg(at)turnstep(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: LISTEN filtering
Date: 2011-06-21 15:58:18
Message-ID: 1f7c19d54a83e5c76cce2221d54241c5@biglumber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160

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.

- --
Greg Sabino Mullane greg(at)turnstep(dot)com
PGP Key: 0x14964AC8 201106211156
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iEYEAREDAAYFAk4Av1UACgkQvJuQZxSWSsgMKACgoM8de4sD0Hya0We2ncxmbsNE
eU0AnjWh8Iqhu8cGMaywGhtxs4rQ7HOh
=M7Ms
-----END PGP SIGNATURE-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sylvain Rabot 2011-06-21 15:58:20 Partitioning and constraint exclusion
Previous Message Lincoln Yeoh 2011-06-21 15:42:24 Re: PostgreSQL 8.4.8 bringing my website down every evening