Re: BUG #1350: Backslash ecape charcter violates ISO/ANSI - Mailing list pgsql-bugs

From Ken Johanson
Subject Re: BUG #1350: Backslash ecape charcter violates ISO/ANSI
Date
Msg-id 41C2F974.7050906@kensystem.com
Whole thread Raw
In response to Re: BUG #1350: Backslash ecape charcter violates ISO/ANSI spec  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: BUG #1350: Backslash ecape charcter violates ISO/ANSI  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
>We have a TODO item:
>
>    * Allow backslash handling in quoted strings to be disabled for
>    portability
>
>      The use of C-style backslashes (.e.g. \n, \r) in quoted strings is not
>      SQL-spec compliant, so allow such handling to be disabled.
>
>Unfortunately that's all we have.  :-)
>
>
>
Thanks, glad to hear it's on the radar. From what I can tell it the
broadest reaching standards incompatibility in the server. And, it's
preventing some project managers from adopting the server as an
alternative to the commercial ones (Its always been an easy-to-cite, and
well justified concern that the backslash behavior is incompatible with
other DBs and specs).

Thx,
ken

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: syntax error causes crafted data to be executed in shell
Next
From: "Belbin, Peter"
Date:
Subject: Re: solaris 10 with gcc 3.3.2