"Gauthier, Dave" <dave.gauthier@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general