# | Trigger Name | Owner | Description |
---|---|---|---|
1 | transactions.check_cash_balance_trigger RETURNS TRIGGER | postgres | |
2 | policy.check_menu_policy_trigger RETURNS TRIGGER | postgres | |
3 | core.disable_editing_sys_type RETURNS TRIGGER | postgres | |
4 | office.hash_password RETURNS TRIGGER | postgres | |
5 | audit.if_modified_func RETURNS TRIGGER | postgres | Track changes to a table at the statement and/or row level. Optional parameters to trigger in CREATE TRIGGER call: param 0: boolean, whether to log the query text. Default 't'. param 1: text[], columns to ignore in updates. Default []. Updates to ignored cols are omitted from changed_fields. Updates with only ignored cols changed are not inserted into the audit log. Almost all the processing work is still done for updates that ignored. If you need to save the load, you need to use WHEN clause on the trigger instead. No warning or error is issued if ignored_cols contains columns that do not exist in the target table. This lets you specify a standard set of ignored columns. There is no parameter to disable logging of values. Add this trigger as a 'FOR EACH STATEMENT' rather than 'FOR EACH ROW' trigger if you do not want to log row values. Note that the user name logged is the login role for the session. The audit trigger cannot obtain the active role because it is reset by the SECURITY DEFINER invocation of the audit trigger its self. |
6 | core.items_unit_check_trigger RETURNS TRIGGER | postgres | |
7 | core.party_after_insert_trigger RETURNS TRIGGER | postgres | |
8 | core.party_before_update_trigger RETURNS TRIGGER | postgres | |
9 | policy.perform_lock_out RETURNS TRIGGER | postgres | |
10 | transactions.restrict_delete_trigger RETURNS TRIGGER | postgres | |
11 | core.shippers_after_insert_trigger RETURNS TRIGGER | postgres | |
12 | core.update_shipping_address_code_trigger RETURNS TRIGGER | postgres | |
13 | office.user_trigger RETURNS TRIGGER | postgres | |
14 | transactions.verification_trigger RETURNS TRIGGER | postgres | |
15 | transactions.verify_stock_master_integrity_trigger RETURNS TRIGGER | postgres |