Subject | RE: [firebird-support] Re: Copy records |
---|---|
Author | Planles |
Post date | 2004-08-05T14:32:19Z |
> >>Violation of PRIMARY or UNIQUE KEY constraints "INTEG_94" on tableThanks Lester for your answer.
> >>"MATCONTI"
> >
> > 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.
table.
I don't know, if I understand it now:
I tought, that if the table has two primary keys, there should be a unique
combination.
What did you mean with "PRIMARY KEY should contain both" ?
Regards,
Primoz