"Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)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 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?
No. Generally that sort of design is a foot-gun ... you should
reconsider the schema arrangement that requires this.
regards, tom lane