[Libreoffice-bugs] [Bug 117897] base/postgres seem to use ODBC brace construct, query fail (...FROM { oj "field"...)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 142480
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142480&action=edit
screen shot of expert configuration settings postgres

(In reply to Peter Gervai from comment #5)
...
> Additionally I cannot select "Advanced", it's grayed out, but that may be
> due to Postgres connector not supporting that.
...
> 
> But I cannot reproduce anymore; and before reporting I upgraded (from
> 1.6.0.2) to see whether it's been fixed (and it wasn't). But now it have
> healed itself, which is pretty rude in the context of bugfixing.
> 
...
> (Honestly, I hardly ever use Base since it's pretty underdocumented, so it
> may be the reason I haven't observed the bug before. )

Just to follow up with you, with the menu access to that configuration no
longer available you can still change the couple of settings for that driver
using the 'Expert Configuraton' tool. 

The screen shot attached is from Libo 6.0.4.

Select Tools->Options->Advanced
Click on "Expert Configuration" 
When that dialog open, enter 'postgres' and click on 'search'
The setting you want to check is 'EnableOuterJoinEscape'.

The default setting, as found after installing that, was 'false'. 

Otherwise, given that it seems to be working for you now I will go ahead and
close as this as working. 

Thanks

-- 
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/20180601/0bf89cf1/attachment.html>