diff options
| author | Lionel Elie Mamane <lionel@mamane.lu> | 2011-09-05 17:29:49 +0200 |
|---|---|---|
| committer | Lionel Elie Mamane <lionel@mamane.lu> | 2011-11-17 21:15:25 +0100 |
| commit | 49cedcb0c713eb49bc39c2331bd279d478f8ad09 (patch) | |
| tree | bad8c6e78cb45d69a61c73ebd3dcc408f9f97689 /connectivity | |
| parent | 37c4d838654b7ab32e81c245ff6a618ceec91f13 (diff) | |
Force LO *not* to use ODBC-specific syntax
Diffstat (limited to 'connectivity')
| -rw-r--r-- | connectivity/source/drivers/postgresql/postgresql.xcu | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/connectivity/source/drivers/postgresql/postgresql.xcu b/connectivity/source/drivers/postgresql/postgresql.xcu index 67b6668844dd..4d455d5863a2 100644 --- a/connectivity/source/drivers/postgresql/postgresql.xcu +++ b/connectivity/source/drivers/postgresql/postgresql.xcu @@ -4,6 +4,7 @@ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. * * Copyright 2008 by Sun Microsystems, Inc. + * Copyright 2011 by Lionel Elie Mamane <lionel@mamane.lu> * * OpenOffice.org - a multi-platform office productivity suite * @@ -35,8 +36,37 @@ <value xml:lang="en-US">PostgreSQL</value> </prop> <node oor:name="Properties"> + <!-- Don't use ODBC syntax for date&time literals and (full) outer joins, + as PostgreSQL does not support it, + but supports the _interior_ of these escapes just fine. --> + <node oor:name="EscapeDateTime" oor:op="replace"> + <prop oor:name="Value" oor:type="xs:boolean"> + <value>false</value> + </prop> + </node> + <!-- Confusingly, this corresponds to "UseBracketedOuterJoinSyntax" in the Features --> + <node oor:name="EnableOuterJoinEscape" oor:op="replace"> + <prop oor:name="Value" oor:type="xs:boolean"> + <value>false</value> + </prop> + </node> </node> <node oor:name="Features"> + <!-- These entries enable the "Advanced Settings" UI to change the settings + whose default is set in node "Properties" above; + as this is guaranteed not to work with PostgreSQL, + we don't let people shoot themselves in the foot and don't enable the UI. --> + <!-- <node oor:name="EscapeDateTime" oor:op="replace"> --> + <!-- <prop oor:name="Value" oor:type="xs:boolean"> --> + <!-- <value>false</value> --> + <!-- </prop> --> + <!-- </node> --> + <!-- Confusingly, this corresponds to "EnableOuterJoinEscape" in the Properties --> + <!-- <node oor:name="UseBracketedOuterJoinSyntax" oor:op="replace"> --> + <!-- <prop oor:name="Value" oor:type="xs:boolean"> --> + <!-- <value>false</value> --> + <!-- </prop> --> + <!-- </node> --> </node> <node oor:name="MetaData"> <node oor:name="Authentication" oor:op="replace"> @@ -48,3 +78,7 @@ </node> </node> </oor:component-data> + +<!-- Local Variables: --> +<!-- indent-tabs-mode: nil --> +<!-- End: --> |