trig_b_iu_set_diagnostic_columns()

Automatically maintains the common table diagnostic columns whenever data is inserted or updated.

General Usage

For UPDATE transactions, the trigger will determine if there are ‘real data changes’, meaning any fields other than the common diagnostic columns being changed by the transaction. If not, only the diag_update_count column will be updated.

To use this trigger, the targeted table must have the following columns / types defined:

• diag_timestamp_created / timestamptz

• diag_role_created / text

• diag_timestamp_modified / timestamptz

• diag_wallclock_modified / timestamptz

• diag_role_modified / text

• diag_row_version / bigint

• diag_update_count / bigint