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

            Bug ID: 130564
           Summary: PostgreSQL ODBC: Unable to create view through
                    Base-GUI, if no view is created before
           Product: LibreOffice
           Version: 6.1.5.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: [email protected]
          Reporter: [email protected]

Connect to a postgreSQL-database through ODBC.
Try to create a view in the table-pane.
Try Insert > View Design - will be greyed out.
Try Insert > View (Simple) - also greyed out.

Now create a view in the database through Tools > SQL:
CREATE VIEW "public"."tview" AS SELECT * FROM "public"."table1"

The view will be created. You could see this after setting View > Refresh
Tables.

Close the *.odb-file after saving it.
Reopen the *.odb-file.

Now the possibility appears to create a view through the GUI of LO. You will
see in the table-pane "Create View" and all the other possibilities are
available.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to