Re: 7.1 triggering capability question

Bashar Chalabi <Bashar@ctl.com> wrote: >A trigger can call a procedure that can run a unix program > >Bashar Assuming the point here is that the unix program could start a separate transaction to do the updates that the original trigger couldn't... ..If the unix program is run synchronously, then the transaction containing the triggering action will still be active. As a result, the triggering row will still be locked and the unix program will not be able to update the triggering row. In fact, if the triggering action was an insert, then the inserted row will not have been committed so there won't really be a row to update yet. The best this approach can do is update *other* rows in the triggering table. I don't think this is what most people want. Correct me if I'm wrong, though. Roger Tomas AG Communication Systems