Forum OpenACS Q&A: Response to can't delete a record in ec_custom_product_field

Thanks for the swift response.

Below is the only trigger I found that deals with ec_custom_product_field_values

create function ec_custom_p_f_values_audit_tr ()
returns opaque as '
begin
        insert into ec_custom_p_field_values_audit (
        product_id,
        last_modified,
        last_modifying_user, modified_ip_address
        ) values (
        old.product_id,
        old.last_modified,
        old.last_modifying_user, old.modified_ip_address
        );
	return new;
end;' language 'plpgsql';

create trigger ec_custom_p_f_values_audit_tr
after update or delete on ec_custom_product_field_values
for each row execute procedure ec_custom_p_f_values_audit_tr();

I noticed that the triger is "after update or delete". I'm going to experiment with the above and see if it solves my problem or it might create a new one.

Thanks Again.

Forum OpenACS Q&A: Response to can't delete a record in ec_custom_product_field_values