[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 Lionel Elie Mamane changed: What|Removed |Added CC||lio...@mamane.lu --- Comment #18 from Lionel Elie Mamane --- As far as I remember, it is just not implemented. Would be an enhancement. Also that the system shows views as views, not as tables. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #17 from Michael --- Thank you @Stang for posts [#15](https://bugs.documentfoundation.org/show_bug.cgi?id=124531#15) and [#16](https://bugs.documentfoundation.org/show_bug.cgi?id=124531#16), but this is not the issue: As Robert Großkopf already had mentioned in the original post > Only possibility to create a view is through Tools > SQL. So there is no progress by now ... -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #16 from Stang --- Created attachment 178251 --> https://bugs.documentfoundation.org/attachment.cgi?id=178251=edit View created - image -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #15 from Stang --- Although only through Tools-> SQL, can create view with native connector using: PostgreSQL 13.6 (Ubuntu 13.6-1.pgdg20.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.3.0-17ubuntu1~20.04) 9.3.0, 64-bit Version: 7.3.0.3 / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #14 from Robert Großkopf --- Bug is still the same in LO 7.3.0.3 on OpenSUSE 15.3 64bit rpm Linux. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 Robert Großkopf changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=13 ||0564 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 Robert Großkopf changed: What|Removed |Added Summary|PostgreSQL Native Driver|PostgreSQL Native Driver: |and ODBC: Unable to create |Unable to create view |view through Base-GUI |through Base-GUI -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #10 from Michael --- (In reply to Robert Großkopf from comment #0) > ... > No problem to create a view through GUI with PostgreSQL and JDBC-driver. Done the same, using PostgreSQL and _ODBC_-Driver. Result = No problem. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #9 from Julien Nabet --- Adding #include at different locations didn't help. The more I look at Postgresql implementation in LO, the more it seems to me quite different than other DBs implementations. I must recognize I'm stuck. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #8 from Julien Nabet --- I wanted to give a try on Debian but there's no simple tuto for installing and above all configuring Postgresql easily contrary to Windows (at least not like http://www.postgresqltutorial.com/install-postgresql/). It's a pity to see that often you're supposed to be a config expert if you're on Linux. Sometimes you just want to be guided to test something quickly, and you don't want to read everything on the subject just to install and setup a quick test. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr --- Comment #7 from Julien Nabet --- On Win10 with master sources updated today I could reproduce this. The feature is disabled here in GetState method: https://opengrok.libreoffice.org/xref/core/dbaccess/source/ui/app/AppController.cxx?r=b1cfdb7b#661 Now we must dig to know why. Perhaps related to the fact that we don't encounter "#include " in postgresql part but it's just a guess. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Blocks||104790 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=104790 [Bug 104790] [META] Database connectivity interfaces (ODBC, JDBC..) and external databases -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #6 from Alex Thurgood --- Hi Robert, I agree, it was merely to comment on the comparison with JDBC. It turns out, however, that my problem with not seeing Create a View with the JDBC connection was transitory. I'm guessing that LO gets confused when an existing ODB using the native driver has its connection properties switched to JDBC. When I open the JDBC-ODB file today in LO652 I can indeed see the Create View entry under Tables, son confirming the comparison you made as well. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #5 from Robert Großkopf --- (In reply to Alex Thurgood from comment #4) > Note however, that I don't see the possibility to create a view even with a > postgres JDBC driver (42.1.1), at least not on Mac I'm using the JDBC from my distribution OpenSUSE 15: postgresql-jdbc-9.4.jar I could see both possibilities there: Creating views in pane "Table" and creating views from a query. But this shouldn't be the problem here. The native connector doesn't offer this but it would be possible to create views through Tools > SQL. Why should we provide a native driver if JDBC-driver works in a better way? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #4 from Alex Thurgood --- Note however, that I don't see the possibility to create a view even with a postgres JDBC driver (42.1.1), at least not on Mac -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 --- Comment #3 from Alex Thurgood --- Confirming also with Version: 6.1.5.2 Build ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 Threads CPU : 4; OS : Mac OS X 10.14.4; UI Render : par défaut; Locale : fr-FR (fr_FR.UTF-8); Calc: group threaded -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 Robert Großkopf changed: What|Removed |Added Version|6.2.2.2 release |6.1.5.2 release Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #2 from Robert Großkopf --- Setting version to 6.1.5.2 and status to NEW. See comment 1. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 124531] PostgreSQL Native Driver: Unable to create view through Base-GUI
https://bugs.documentfoundation.org/show_bug.cgi?id=124531 Michael changed: What|Removed |Added CC||noz...@web.de --- Comment #1 from Michael --- Same misbehaviour here: Tested with Version: 6.1.5.2 Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805 CPU-Threads: 4; BS: Linux 4.18; UI-Render: Standard; VCL: kde4; Gebietsschema: de-DE (de_DE.UTF-8); Calc: group threaded on kUBUNTU 18.04.2 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs