You need a PostgreSQL-database for testing. Open a PostgreSQL-database with the native connector of LO. Have a look at pane "Tables". No possibility to create a view through GUI in the pane "Tables". Have a look at pane "Queries". No possibility to create a view from an existing query, when clicking with right mousebutton on a query and searching through the content-menue. Only possibility to create a view is through Tools > SQL. No problem to create a view through GUI with PostgreSQL and JDBC-driver. Tested with Version: 6.2.2.2 Build-ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d CPU-Threads: 6; BS: Linux 4.12; UI-Render: Standard; VCL: gtk3; Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE Calc: threaded on OpenSUSE 15 64bit rpm Linux
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
Setting version to 6.1.5.2 and status to NEW. See comment 1.
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
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
(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?
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.
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 <connectivity/sdbcx/VCollection.hxx>" in postgresql part but it's just a guess.
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.
Adding #include <connectivity/sdbcx/VCollection.hxx> 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.
(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.
> (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. Then we are using different PostgreSQL-connections with ODBC. I can't create a view with ODBC through GUI (as I can't create it through dircet connection). There is no possibility in the menue of the queries (right mouseclick on a query), no possibility in the table pane and no possibility through Edit > Create a View I have changed the summary to refelect this.
I have tested it again: Nothing changed for native driver. There is no possibility to create a view in GUI. For ODBC the possibility to create a view will appear, if you have already created a view in your database (Tools > SQL). So this is a different bug.
Dear Robert Großkopf, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Bug is still the same in LO 7.3.0.3 on OpenSUSE 15.3 64bit rpm Linux.
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
Created attachment 178251 [details] View created - image
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 ...
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.
Bug is still the same in LO 24.2.0.3 on OpenSUSE 15.4 64bit rpm Linux.