Re: Stop trigger fireing for a specific user?

From: Richard Huxton <dev(at)archonet(dot)com>
To: glynastill(at)yahoo(dot)co(dot)uk
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Stop trigger fireing for a specific user?
Date: 2008-09-19 10:35:16
Message-ID: 48D38064.5070407@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrea Moretto 2008-09-19 10:48:49 Re: Query planner issue
Previous Message Richard Huxton 2008-09-19 10:33:41 Re: Query planner issue