https://bugs.documentfoundation.org/show_bug.cgi?id=161906

--- Comment #5 from Robert Großkopf <[email protected]> ---
Changed the SQL-Code a little bit.

CREATE TABLE IF NOT EXISTS schema_a.MyTable (LIKE CommmonTable INCLUDING ALL) ;

won't work in Base, because the Schema name is missing for CommonTable.

Also removed all what was about user "postgres". Run the code in Tools → SQL by
an existing PostgreSQL database here.

Then tested:
Clicked on one query to set the path.
Opened the form.
Content will be shown.
Closed the form.
Clicked on the other query to est the other path.
Opened the form.
Other content will be shown.

Same when switching the path and reloading the form.

So I couldn't find any buggy behavior with
Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
on OpenSUSE 15.6 64bit rpm Linux
with direct connection to PostgreSQL or JDBC-connection to PostgreSQL.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to