-- -- ec_retailers_audit_tr/0 -- create or replace function ec_retailers_audit_tr( ) returns trigger as $$ begin insert into ec_retailers_audit ( retailer_id, retailer_name, primary_contact_name, secondary_contact_name, primary_contact_info, secondary_contact_info, line1, line2, city, usps_abbrev, zip_code, phone, fax, country_code, reach, url, nexus_states, financing_policy, return_policy, price_guarantee_policy, delivery_policy, installation_policy, last_modified, last_modifying_user, modified_ip_address ) values ( old.retailer_id, old.retailer_name, old.primary_contact_name, old.secondary_contact_name, old.primary_contact_info, old.secondary_contact_info, old.line1, old.line2, old.city, old.usps_abbrev, old.zip_code, old.phone, old.fax, old.country_code, old.reach, old.url, old.nexus_states, old.financing_policy, old.return_policy, old.price_guarantee_policy, old.delivery_policy, old.installation_policy, old.last_modified, old.last_modifying_user, old.modified_ip_address ); return new; end;$$ language plpgsql;