Postgres Pro
Downloads
Home   >   mailing lists

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

From Glyn Astill
Subject Stop trigger fireing for a specific user?
Date
Msg-id 382802.10822.qm@web25803.mail.ukl.yahoo.com
Whole thread Raw
Responses Re: Stop trigger fireing for a specific user?
List pgsql-general
Tree view 
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
theC 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
matchedmy user.

pgsql-general by date:

Previous
From: Yi Zhao
Date:
Subject: Re: how to return the first record from the sorted records which may have duplicated value.
Next
From: "Pavel Stehule"
Date:
Subject: Re: Synchronize two similar tables: recursive triggers