Discerning user vs trigger based updates

From: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Discerning user vs trigger based updates
Date: 2010-11-23 17:13:38
Message-ID: 482E80323A35A54498B8B70FF2B87980047B725E29@azsmsx504.amr.corp.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-11-23 17:21:28 Re: Discerning user vs trigger based updates
Previous Message c k 2010-11-23 16:44:38 plpyhton