L.S. I'd like to prevent updates on a specific field when done during regular use or during the execution of any non-deferred trigger, while allowing them when done from deferred triggers. (BTW, we're talking version 8.1 here).
Currently there doesn't seem to be a way to know whether code is executed during a regular trigger call or during a deferred trigger call? I.e. something in the line of TG_WHEN and a bit more to the point then looking whether TG_ARGV[] contains the deferred keywords..... So, am I overlooking a way to get to this info? And if not, could this be considered an item for the todo list? Ratio: when deferred triggers on table A are used to calculate field values of table B (which then obviously need an update), one might want to prevent direct updates on these fields of table B -- Best, Frank. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
