https://bugs.documentfoundation.org/show_bug.cgi?id=160375
Robert Großkopf <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #2 from Robert Großkopf <[email protected]> --- 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.
