Re: Stop trigger fireing for a specific user? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Stop trigger fireing for a specific user?
Date
Msg-id 48D38064.5070407@archonet.com
Whole thread Raw
In response to Stop trigger fireing for a specific user?  (Glyn Astill <glynastill@yahoo.co.uk>)
Responses Re: Stop trigger fireing for a specific user?
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Query planner issue
Next
From: Andrea Moretto
Date:
Subject: Re: Query planner issue