I have 2 master table (mst_customer, mst_order) and 1 transaction_table.
I’ve problem when i doing insert transaction, error with message : “error transaction in golang : insert or update on table “tx_transaction” violates foreign key constraint “tx_transaction_no_order_fkey”.
I have confirmed that the no_order and id_customer are correct and in the mst_order table
design table in postgresql

please help me

When i doing insert transaction to tx_transaction, it’s can update colomn total in mst_order