[Libreoffice-bugs] [Bug 130564] New: PostgreSQL ODBC: Unable to create view through Base-GUI, if no view is created before

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: robert at familiegrosskopf.de

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200210/c4b3a127/attachment.htm>