[Libreoffice-bugs] [Bug 112722] Issue on setting up Relationship
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Mon Dec 11 15:41:43 UTC 2017
https://bugs.documentfoundation.org/show_bug.cgi?id=112722
--- Comment #8 from robert at familiegrosskopf.de ---
(In reply to perie_gut from comment #6)
> As of the latest version, I still was not able to saved the relationship for
> the following:
>
> ContractDetails.BargainPurchaseOptionType =
> BargainPurchaseOption.BargainPurchaseOption
>
> *also for the BargainRenewalOption
>
> and I have tried to manually create the relationship (from insert >
> relationship) and got the following error
>
> SQL Status: S0011
> Error code: -170
>
> Primary or unique constraint required on main table: "BargainRenewalOption"
> in statement [ALTER TABLE "ContractDetails" ADD FOREIGN KEY
> ("BargainRenewalOption") REFERENCES "BargainRenewalOption"
> ("BargainRenewalOption")]
Error appears, because "BargainRenewalOption" isn't unique. There are two
primary-keys in the table. So how should the database be able to know which of
the different rows of "BargainRenewalOption" will be the right?
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171211/3c4edaab/attachment.html>
More information about the Libreoffice-bugs
mailing list