If I understand correctly, to use the updated NEW.heading value, we'd have to modify the trigger names so that update_headings_tgr() runs before aaa_auth_ingest_or_delete().
Fortunately, update_headings_tgr() does not appear to have any side effects beyond modifying NEW.heading and NEW.simple_heading.
Any concerns about renaming update_headings_tgr() to aaaa_update_headings_tgr() ?
If I understand correctly, to use the updated NEW.heading value, we'd have to modify the trigger names so that update_ headings_ tgr() runs before aaa_auth_ ingest_ or_delete( ).
Fortunately, update_ headings_ tgr() does not appear to have any side effects beyond modifying NEW.heading and NEW.simple_heading.
Any concerns about renaming update_ headings_ tgr() to aaaa_update_ headings_ tgr() ?