here the Duplication means the object table obj_id which is a primary key i duplicated twice
Here my question is for primary key (obj_id) , we are getting two entries for the same primary id which must be unique since the database is large i am pasting the db bump output CREATE TABLE objects (obj_id integer primary key, class_id integer, dn text, last_ccb integer); INSERT INTO "objects" VALUES(1,127,'APG43L_DDISKPATH=ACS_ACA_DATA,safApp=safImmService',0); INSERT INTO "objects" VALUES(2,127,'APG43L_DDISKPATH=ACS_ALEC_DATA,safApp=safImmService',0); INSERT INTO "objects" VALUES(3,127,'APG43L_DDISKPATH=ACS_CHB_DATA,safApp=safImmService',0); INSERT INTO "objects" VALUES(4,127,'APG43L_DDISKPATH=ACS_DATA,safApp=safImmService',0); INSERT INTO "objects" VALUES(5,127,'APG43L_DDISKPATH=ACS_DATA_BASE,safApp=safImmService',0); INSERT INTO "objects" VALUES(6,127,'APG43L_DDISKPATH=ACS_LOGS,safApp=safImmService',0); INSERT INTO "objects" VALUES(7,127,'APG43L_DDISKPATH=ACS_LOGS_BASE,safApp=safImmService',0); INSERT INTO "objects" VALUES(8,127,'APG43L_DDISKPATH=ACS_MTZ_DATA,safApp=safImmService',0); INSERT INTO "objects" VALUES(9,127,'APG43L_DDISKPATH=ACS_RTR_DATA,safApp=safImmService',0); | | | INSERT INTO "objects" VALUES(1304,155,'entryId=6,tableId=CPIdTable,CSId=1',0); INSERT INTO "objects" VALUES(1305,155,'entryId=6,tableId=HWCTable,CSId=1',0); INSERT INTO "objects" VALUES(1306,155,'entryId=6,tableId=NETable,CSId=1',0); INSERT INTO "objects" VALUES(1307,155,'entryId=60,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1308,155,'entryId=61,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1309,155,'entryId=62,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1310,155,'entryId=63,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1311,155,'entryId=64,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1312,155,'entryId=65,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1313,155,'entryId=66,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1314,155,'entryId=67,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1315,155,'entryId=68,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1309,155,'entryId=99,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1310,118,'externalMediaFunctionMId=1,safApp=safImmService',0); INSERT INTO "objects" VALUES(1311,115,'fileOutputId=1,statisticalCounterMId=1,safApp=safImmService',0); INSERT INTO "objects" VALUES(1312,114,'filterId=1,ldapId=1,ldapAuthenticationMethodId=1',0); Here the obj_id which is primary is having duplicate primary value entries INSERT INTO "objects" VALUES(1309,155,'entryId=62,tableId=CPGMembersTable,CSId=1',0); INSERT INTO "objects" VALUES(1309,155,'entryId=99,tableId=CPGMembersTable,CSId=1',0); can some one please tell me why the primary key is coming twice -Neel. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users