Update Data in PostgreSQL's Transfer_product Table Using Order_product Table and Date Range Condition

PostgreSQL Concurrency Issues with Multiple Updates to the Same Row