"Miguel Carvalho" <miguel@ipatimup.pt> writes:
> The trigger code will force another trigger fire because of the changes
> in the record. I'm i right?
No, altering the NEW record doesn't cause any additional trigger
firings. If it did, such a trigger would be infinitely recursive.
Your DELETE issued by the trigger would cause firing of ON DELETE
triggers, but not another firing of ON UPDATE.
regards, tom lane