Forum OpenACS Q&A: Response to Postgres Problem -again

I was able to recreate your problem on ec_user_class_user_map.  After dropping the table and recreating it, you need to also re-add the indexes and the triggers on ec_user_class_user_map.  The problems seems to be with the ec_user_class_user_audit_tr trigger.  I don't have time to follow through on it right now, but you might want to try changing the audit trigger from a before to an after trigger.