Error Number: 1526

Hello,

Having a little issue, and can't seem to figure it out!

Every time I try to run this insert command I get this error:

select code, name, fee, med_tos, cpt_code FROM billing_code WHERE code
= '11100'

SELECT bill_code, fee_code, amount, med_tos, cpt_code FROM fee_detail
WHERE bill_code = '11100' and fee_code = 'STANDARD'

insert into billing_detail (item, sub_item, clienttype, client, patient,
invoice, date, end_date, age_date, employee, user_code, user_time,
user_date, code, code_type, diag, med_pos, med_tos, mod1, mod2, descr,
amount, units, extended, item_bal, bill_pat, bill_ins, bill_never,
deduct, pat_resp, est_done, est_billed, taxable, posted, inventory,
inv_posted, paid, note_ins, note_stmt, emg, notes) VALUES (1,
1,'S','KENA000002','KENA000002',76964,'2007-11-06','2007-11-06','2007-11
-06','','','12:02 PM','2007-11-06','11100','CH','1234', '', '01', '',
'', 'BX, SKIN, SUBQ/MUCOUS MEMBRANE (SEP PROC', 150.00, 1, 150.00,
150.00, FALSE, FALSE, FALSE, TRUE, 0.00, FALSE, FALSE, FALSE, FALSE,
1.00, FALSE, FALSE, FALSE, FALSE, 'N', 'Imported From SOAPware')
Error Number: 1526
Error: Connectivity error: ERROR: duplicate key violates unique
constraint "billing_detail_pkey";Error while executing the query
12:02:39.452 PM

What's more interesting is if I exit everyone out of the program or run
this on a not shared version of the program the command works fine!?

Only one constraint:

-- Constraint: billing_detail_pkey

-- ALTER TABLE billing_detail DROP CONSTRAINT billing_detail_pkey;

ALTER TABLE billing_detail
ADD CONSTRAINT billing_detail_pkey PRIMARY KEY(rec_no);

Any help is appreciated!

Thanks,

Shahid Khan