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

From Tom Lane
Subject Re: Discerning user vs trigger based updates
Date
Msg-id 11364.1290532888@sss.pgh.pa.us
Whole thread Raw
In response to Discerning user vs trigger based updates  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
"Gauthier, Dave" <dave.gauthier@intel.com> writes:
> I have an update trigger on a table that in turn updates other records of that same table.  I need to be able to
discernbetween when a user is updating a record in the table vs when the update trigger is reflexively calling itself.
Isthere an elegant way to do this? 

No.  Generally that sort of design is a foot-gun ... you should
reconsider the schema arrangement that requires this.

            regards, tom lane

pgsql-general by date:

Previous
From: "Gauthier, Dave"
Date:
Subject: Discerning user vs trigger based updates
Next
From: "Jonathan Tripathy"
Date:
Subject: Syntax error near returning