Re: Access issue again

On Saturday 29 March 2008 4:50 pm, Andreas wrote:
> Hi,
>
> whenever I ODBC link pg-tables into access I get this error in the log:
> It's translated by me so it won't be the original english error text.
> -----------------
> 2008-03-30 00:28:45 CET db_sales user1 WARNING:  not standardconform use
> of \\ in  characterstring at char 264
> 2008-03-30 00:28:45 CET db_sales user1 TIP:  Use the Syntax for
> Escape-strings for Backslashes, e.g. E'\\'.
> ------------------
>
> Besides this error the linked tables seem to work perfectly.
> Whats wrong here?

See this:

http://www.postgresql.org/docs/8.3/interactive/runtime-config-compatible.html

escape_string_warning (boolean)

    When on, a warning is issued if a backslash (\) appears in an ordinary
string literal ('...' syntax) and standard_conforming_strings is off. The
default is on.

    Applications that wish to use backslash as escape should be modified to
use escape string syntax (E'...'), because the default behavior of ordinary
strings will change in a future release for SQL compatibility. This variable
can be enabled to help detect applications that will break.

standard_conforming_strings (boolean)

    This controls whether ordinary string literals ('...') treat backslashes
literally, as specified in the SQL standard. The default is currently off,
causing PostgreSQL to have its historical behavior of treating backslashes as
escape characters. The default will change to on in a future release to
improve compatibility with the standard. Applications can check this
parameter to determine how string literals will be processed. The presence of
this parameter can also be taken as an indication that the escape string
syntax (E'...') is supported. Escape string syntax should be used if an
application desires backslashes to be treated as escape characters.

You can change the escape_string_warning to escape_string_warning=False in
postgresql.conf to suppress the messages.
--
Adrian Klaver
aklaver@comcast.net