|Subject||RE: [firebird-support] Re: Copy records|
> >>Violation of PRIMARY or UNIQUE KEY constraints "INTEG_94" on tableThanks Lester for your answer.
> > Maybe I should tell before, that both MC_MAT_KEY and MC_MAT_KC
> are primary keys.
> If just the combination should be unique then the PRIMARY KEY shouldThe combination of both should be unique. There is no generator in this
> contain both, but if MC_MAT_KEY is a generator, the it will always be
> unique, so just drop MC_MAT_KC from the primary key.
I don't know, if I understand it now:
I tought, that if the table has two primary keys, there should be a unique
What did you mean with "PRIMARY KEY should contain both" ?