https://bugs.documentfoundation.org/show_bug.cgi?id=160375
Robert Großkopf <rob...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |rob...@familiegrosskopf.de
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
--- Comment #2 from Robert Großkopf <rob...@familiegrosskopf.de> ---
Have tested this with LO 24.2.2.2 on OpenSUSE:
Created two tables in different schema.
Tried to link this tables in Tools → Relationship.
Doesn't work with the code, which has been send by Base:
ALTER TABLE "public"."tbl_user" ADD FOREIGN KEY ("Town_ID") REFERENCES
"tbl_town" ("ID")
Changed this code and send it through Tools → SQL:
ALTER TABLE "public"."tbl_user" ADD FOREIGN KEY ("Town_ID") REFERENCES
"accounting"."tbl_town" ("ID")
Will work. After closing the Base file and reopening it the relation will be
shown in Tools → Relationship.
I'm using direct connection to PostgreSQL here.
Think this never worked.
Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 6; OS: Linux 5.14; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
