LISTEN filtering

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема LISTEN filtering
Дата
Msg-id 1f7c19d54a83e5c76cce2221d54241c5@biglumber.com
обсуждение исходный текст
Ответы Re: LISTEN filtering  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: LISTEN filtering  (Merlin Moncure <mmoncure@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: PostgreSQL 8.4.8 bringing my website down every evening
Следующее
От: Sylvain Rabot
Дата:
Сообщение: Partitioning and constraint exclusion