troubleshooting Question

I can't create a primary key in Interbase 6.5

Avatar of j18
j18 asked on
Databases
2 Comments1 Solution701 ViewsLast Modified:
Hi there!

As a part of small update on my database. I tried to create a primary key on the table called Transact. This table contains the entity called 'CODE'. I am using gerator ( defined in the database as TRANSACT_CODE_GEN) to supply the value.  There is no chance of duplicate values for entity CODE.

There was one primary key on this table and index related to this primary key as under:
PK_TRANSACT_DOCKET_SITEID & UNI_TRANS_CODE_INDEX

Despite of making sure that, there is no duplicate value in CODE,no similar primary key, I keep getting this error message while creating a new primary key.
"Attempt to store duplicate value (visible to active transactions) in unique index "RDB$PRIMARY79"
Statement: alter table transact add CONSTRAINT PK_TRANSACT_CODE PRIMARY KEY (CODE)"

I have tried converting the database in the latest version of Interbase 2007 and 7.5 and this error doesn't come up in the latest version.

Would any one please assist me to either rectify this or tell me, If there is any issue with Interbase 6.5?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros