Re: [GENERAL] Discerning user vs trigger based updates

2010-11-23 Thread Tom Lane
"Gauthier, Dave" 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 d

[GENERAL] Discerning user vs trigger based updates

2010-11-23 Thread Gauthier, Dave
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