-- -- ec_picklist_items_audit_tr/0 -- create or replace function ec_picklist_items_audit_tr( ) returns trigger as $$ begin insert into ec_picklist_items_audit ( picklist_item_id, picklist_item, picklist_name, sort_key, last_modified, last_modifying_user, modified_ip_address ) values ( old.picklist_item_id, old.picklist_item, old.picklist_name, old.sort_key, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;$$ language plpgsql;