-- -- ec_product_recommend_audit_tr/0 -- create or replace function ec_product_recommend_audit_tr( ) returns trigger as $$ begin insert into ec_product_recommend_audit ( recommendation_id, product_id, user_class_id, recommendation_text, active_p, category_id, subcategory_id, subsubcategory_id, last_modified, last_modifying_user, modified_ip_address ) values ( old.recommendation_id, old.product_id, old.user_class_id, old.recommendation_text, old.active_p, old.category_id, old.subcategory_id, old.subsubcategory_id, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;$$ language plpgsql;