Skip site navigation (1) Skip section navigation (2)

Error Number: 1526

From: "Shahid Khan" <ShahidK(at)x-link(dot)info>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Error Number: 1526
Date: 2007-11-06 17:14:26
Message-ID: 44744676BA63674CAE733AA7D04D185D3F35CF@internetserver.x-link.local (view raw or flat)
Thread:
Lists: pgsql-odbc
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 

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2007-11-07 04:53:34
Subject: Re: Error Number: 1526
Previous:From: Richard Broersma JrDate: 2007-11-06 16:01:47
Subject: Re: Either I broke PostgreSQL or I found an ODBC bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group