Duplicate key - Mailing list pgsql-interfaces

From Miguel Omar Carvajal
Subject Duplicate key
Date
Msg-id 02031410360001.06591@power9.carvajal.com
Whole thread Raw
List pgsql-interfaces
Hi all,
  I am having a problem with PostgreSQL 7.1.3 using Redhat 7.1 and it is the
following: I have a program I am making in C++ that is sending four simple
insert commands to postgres and I keep getting an "ERROR:  Cannot insert a
duplicate key into unique index dbshpawb001"(this is what I see when I put
postmaster in debug level 4, see attached file.) the inserts are:

insert into dbshpawb
("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_
no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time"

,"upd_date","pckgs","container_no","package_no","real_weight","weight_units")values('2','3','5','25','3','234','1','A','29','08:55:01PM','03/12/02','29',
'08:55:01PM','03/12/02','1','1','1','10','P');insert into dbshpawb
("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_
no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time"

,"upd_date","pckgs","container_no","package_no","real_weight","weight_units")values('2','3','5','25','3','235','1','A','29','08:55:01PM','03/12/02','29',
'08:55:01PM','03/12/02','1','1','2','4','P'); insert into dbshpawb
("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_
no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time"

,"upd_date","pckgs","container_no","package_no","real_weight","weight_units")values('2','3','5','25','3','236','1','A','29','08:55:02PM','03/12/02','29',
'08:55:02PM','03/12/02','1','1','3','20','P');insert into dbshpawb
("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_
no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time"

,"upd_date","pckgs","container_no","package_no","real_weight","weight_units")values('2','3','5','25','3','237','1','A','29','08:55:02PM','03/12/02','29',
'08:55:02PM','03/12/02','1','1','4','90','P');

the table structure is:

CREATE TABLE "dbshpawb" (     "courier_id" int4,     "pos_shipper" int2,     "pos_recipient" int2,     "manifest_no"
int4,    "pos_sender" int2,     "bill_no" int4,     "status" char(1),     "cap_user" int8,     "cap_date" date,
"cap_time"time,     "upd_user" int8,     "upd_date" date,     "upd_time" time,     "pckgs" int2,     "container_no"
int2default 0,     "package_no" int2 default 0,     "real_weight" real default 0,     "weight_units" char(1),
"pckg_no"int2 default 0
 
);
CREATE UNIQUE INDEX "dbshpawb001" on "dbshpawb" using btree (       "courier_id" "int4_ops",       "pos_shipper"
"int2_ops",      "pos_recipient" "int2_ops",       "manifest_no" "int4_ops",       "container_no" "int2_ops",
"pos_sender""int2_ops",       "bill_no" "int4_ops"
 
);

can someone please shed some light on what I am doing wrong?

Thanks in advance,
Omar Carvajal

-------------------------------------------------------

pgsql-interfaces by date:

Previous
From: "Nicolas Bazin"
Date:
Subject: Re: ecpg weird behavior
Next
From: Thomas Lockhart
Date:
Subject: Re: ecpg weird behavior