<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - base/postgres seem to use ODBC brace construct, query fail (...FROM { oj "field"...)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117897#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - base/postgres seem to use ODBC brace construct, query fail (...FROM { oj "field"...)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117897">bug 117897</a>
from <span class="vcard"><a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> <span class="fn">Drew Jensen</span></a>
</span></b>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=142480" name="attach_142480" title="screen shot of expert configuration settings postgres">attachment 142480</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=142480&action=edit" title="screen shot of expert configuration settings postgres">[details]</a></span>
screen shot of expert configuration settings postgres
(In reply to Peter Gervai from <a href="show_bug.cgi?id=117897#c5">comment #5</a>)
...
<span class="quote">> Additionally I cannot select "Advanced", it's grayed out, but that may be
> due to Postgres connector not supporting that.</span >
...
<span class="quote">>
> 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.
> </span >
...
<span class="quote">> (Honestly, I hardly ever use Base since it's pretty underdocumented, so it
> may be the reason I haven't observed the bug before. )</span >
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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>