problems changing postgres jdbc driver - Mailing list pgsql-odbc

we have table ap_invoice_t

Referenced by:
    TABLE "ap_invoice_m" CONSTRAINT "ap_invoice_m_fkey" FOREIGN KEY (branch_cod, orig_doc, doc_year, azienda) REFERENCES "123".ap_invoice_t(branch_cod, orig_doc, doc_year, azienda) ON DELETE CASCADE


the following operations are executed  in order:

DELETE FROM ap_invoice_t WHERE branch_cod = '2150100078' and doc_year = '2015' and orig_doc = '0000079369'and azienda='CX';
--'2150100078', $2 = '2015', $3 = '0000079369'

DELETE FROM ap_invoice_m WHERE branch_cod = '2150100078' and doc_year = '2015' and orig_doc = '0000079369'and azienda='CX';

INSERT INTO ap_invoice_t (branch_cod, doc_year, orig_doc, amount, az_remota, branch_ad2, branch_ad3, branch_ad4, branch_ad5, branch_nam, cage1, cage2,
cage3, cdes1, cdes2, cdes3, cfab1, cfab2, cfab3, data_manut, data_par, dept, descr, doc_date, doc_type, esito, file_ref, house_bl, lcl_fcl,
loc_destin, master_bl, mov_nr, notes, orig_ref, porto_car, porto_sca, targa, valuta, vettore, azienda)
values
($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35, $36, $37, $38, $39, $40)

$1 = '2150100078', $2 = '2015', $3 = '0000079369', $4 = '150', $5 = '60', $6 = '19 MAYIS CAD. GOLDEN PLAZA NO : 3 KAT : 2', $7 = 'SISLI, ISTANBUL 34360', $8 = 'Tel. +90 212 395 1440', $9 = 'Fax. +90 212 355 3505', $10 = 'SAVINO DEL BENE NAKLIYAT A.S. ISTANBUL', $11 = '', $12 = '', $13 = '', $14 = 'SALAR PREFAB', $15 = 'KOYA MAIN STREET', $16 = ' ', $17 = 'DI IORIO SPA', $18 = 'ZONA INDUSTRIALE IL GIARDINO', $19 = ' S.ELENA SANNITA', $20 = '2016-03-08 00:00:00', $21 = '2016-03-08', $22 = '03', $23 = 'FURNITURE', $24 = '2015-12-11', $25 = 'DB', $26 = 'Y', $27 = 'XXXXCX', $28 = 'SDB01S106320', $29 = 'F', $30 = '', $31 = 'ARKAOI0000000658', $32 = '000001407', $33 = ' ARKU841046/6 Supplier Inv.: 981/01,979/01 ', $34 = 'O50686', $35 = 'ANCONA', $36 = 'MERSIN', $37 = NULL, $38 = 'USD', $39 = 'TA', $40 = 'CX'


INSERT INTO ap_invoice_m (branch_cod, cod_voce, doc_year, orig_doc, progr, des_voce, imp_voce, azienda) values ($1, $2, $3, $4, $5, $6, $7, $8)
DETAIL:  parameters: $1 = '2150100078', $2 = 'M01', $3 = '2015', $4 = '0000079369', $5 = '1', $6 = 'OCEAN IMPORT FREIGHT', $7 = '150', $8 = 'CX'
ERROR:  insert or update on table "ap_invoice_m" violates foreign key constraint "ap_invoice_m_fkey"
DETAIL:  Key (branch_cod, orig_doc, doc_year, azienda)=(2150100078 , 0000079369 , 2015, CX ) is not present in table "ap_invoice_t".
STATEMENT:  INSERT INTO ap_invoice_m (branch_cod, cod_voce, doc_year, orig_doc, progr, des_voce, imp_voce, azienda) values ($1, $2, $3, $4, $5, $6, $7, $8)

as you se we get unexpectedly Foreing key violation 


Please advise

--

Silvio Brandani