[Libreoffice-bugs] [Bug 137442] Postgresql schema missing in Table Filter

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from mshiner at uzerp.com ---
(In reply to Alex Thurgood from comment #3)
> @mshiner : my understanding of 
> 
> https://doc.uzerp.com/faq/power-user/
> 
> is that the reports schema is for server-side views.
> 
> I could be wrong, but I don't think the table filter dialog takes into
> account views as tables with the postgresql driver.
> 
> You might find a reading of bug 67649 helpful (or not) regarding how SDBC
> functionality considers server side views.

Alex

The reports schema does contain server side views, as does the public
schema..... this has never been a problem in the past with this database.

I tripped this over as I added a new server side view within the reports schema
and it didn't show in calc. So I went to the base file to amend the table
filter (which had been previously set to only expose certain views from public
and reports) and the reports schema disappeared.

-- 
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/20201029/5d8f01db/attachment.htm>