Re: LISTEN filtering

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: LISTEN filtering
Дата
Msg-id BANLkTimRDKjBNsova_eFo=fe4AXic03yNQ@mail.gmail.com
обсуждение исходный текст
Ответ на LISTEN filtering  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: LISTEN filtering  ("Greg Sabino Mullane" <greg@turnstep.com>)
Список pgsql-general
On Tue, Jun 21, 2011 at 10:58 AM, Greg Sabino Mullane <greg@turnstep.com> 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

В списке pgsql-general по дате отправления:

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