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-----
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 |