Stop trigger fireing for a specific user?

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Stop trigger fireing for a specific user?
Date: 2008-09-19 09:14:21
Message-ID: 382802.10822.qm@web25803.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-09-19 09:14:25 Re: Synchronize two similar tables: recursive triggers
Previous Message Yi Zhao 2008-09-19 09:10:58 Re: how to return the first record from the sorted records which may have duplicated value.