Discerning user vs trigger based updates - Mailing list pgsql-general

From Gauthier, Dave
Subject Discerning user vs trigger based updates
Date
Msg-id 482E80323A35A54498B8B70FF2B87980047B725E29@azsmsx504.amr.corp.intel.com
Whole thread Raw
Responses Re: Discerning user vs trigger based updates
List pgsql-general

Hi:

 

I have an update trigger on a table that in turn updates other records of that same table.  I need to be able to discern between when a user is updating a record in the table vs when the update trigger is reflexively calling itself.  Is there an elegant way to do this?

 

Thanks in Advance

pgsql-general by date:

Previous
From: c k
Date:
Subject: plpyhton
Next
From: Tom Lane
Date:
Subject: Re: Discerning user vs trigger based updates