LISTEN filtering - Mailing list pgsql-general

From Greg Sabino Mullane
Subject LISTEN filtering
Date
Msg-id 1f7c19d54a83e5c76cce2221d54241c5@biglumber.com
Whole thread Raw
Responses Re: LISTEN filtering
Re: LISTEN filtering
List 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@turnstep.com
PGP Key: 0x14964AC8 201106211156
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

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

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



pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: PostgreSQL 8.4.8 bringing my website down every evening
Next
From: Sylvain Rabot
Date:
Subject: Partitioning and constraint exclusion