Seeing errors while running the provided update script:\n\nupdate ropa_purchase as rp\nfrom purchase_fpdate as pf\nset rp.fp_date = pf.pfrdate\nwhere rp.purchase_id = pf.purchase_id\nExecuting . . .\n\nE_US125D Ambiguous replace: you have specified several replacements for\n    the same row.\n    (Tue Apr 19 15:35:12 2022)\n\nIts where you try to update one row more than once \ni.e.,\nropa_purchase as rp has two fields, purchase_id and fp_date so a row might be purchase_id='1001' and fp_date='04/01/2022'\n\npurchase_fpdate as pf is where the updates will be coming from if rp.purchase_id = pf.purchase_id so it may have rows that have  \npurchase_id='1001' and pfr_date='04/02/2022'\npurchase_id='1001' and pfr_date='04/03/2022'\npurchase_id='1001' and pfr_date='04/04/2022'\n\nIt seems that during a deferred update statement, ambiguous replace errors will occur if the same row is updated more than once. \nThis is the correct action as specified in the "INGRES/SQL reference manual". \nQueries that hadn't shown the error "E_US125D Ambiguous Replace error" before and now give this error were always incorrect. This error is now correctly trapped.\nThe usual cause of this error are tables that allow duplicate rows being use in the query.\n\nYou should check on this error first and consistency of the tables ropa_purchase and ropa_payment; and the SQL statements.\n\n\n