Re: Stop trigger fireing for a specific user?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Stop trigger fireing for a specific user?
Дата
Msg-id 48D38064.5070407@archonet.com
обсуждение исходный текст
Ответ на Stop trigger fireing for a specific user?  (Glyn Astill <glynastill@yahoo.co.uk>)
Ответы Re: Stop trigger fireing for a specific user?  (Glyn Astill <glynastill@yahoo.co.uk>)
Список pgsql-general
Glyn Astill wrote:
> I've a trigger written in C and I want to stop it fireing for a
> specific user. Is ther any way to do this outside of the C code in
> the trigger function?
>
> The only way I can think so far is to do a select SESSION_USER in the
> trigger function and skip the action if it matched my user.

That's exactly it. I'm not sure it will ever be a built-in feature,
everyone's requirements will be slightly different.

--
  Richard Huxton
  Archonet Ltd

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Query planner issue
Следующее
От: Andrea Moretto
Дата:
Сообщение: Re: Query planner issue