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

Re: Error Number: 1526

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Shahid Khan <ShahidK(at)x-link(dot)info>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Error Number: 1526
Date: 2007-11-07 04:53:34
Message-ID: 473144CE.2050201@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Shahid Khan wrote:
> 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);

How is the rec_no field defined ?

regards,
Hiroshi Inoue


In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2007-11-07 05:06:41
Subject: Re: Either I broke PostgreSQL or I found an ODBC bug
Previous:From: Shahid KhanDate: 2007-11-06 17:14:26
Subject: Error Number: 1526

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