Thread: BUG #3872: backslash_quote = off doesn't work any more

The following bug has been logged online:

Bug reference:      3872
Logged by:          David Gradwell
Email address:      david@gradwell.com
PostgreSQL version: 8.3-beta3
Operating system:   Windows Server 2003
Description:        backslash_quote = off doesn't work any more
Details:

set backslash_quote = off in postgresql.conf


create table a (a1 varchar(100))

insert into a(a1)   values ( '\602')

gives ERROR: invalid byte sequence for encoding "UTF8": 0x82'

It worked fine in 8.2 !!

In fact to meet the sql standard we shouldn't have to change the conf file.
The default should be SQL compliance !!

I can email the current and 8.2 conf files if helpful.

Thanks

On Mon, 14 Jan 2008, David Gradwell wrote:

> Description:        backslash_quote = off doesn't work any more

I think you need to
    set standard_conforming_strings=on;
instead.

Then:
    select '\''012'::text;
     text
    -------
     \'012
    (1 row)

     select '\012'::text;
     text
    ------
     \012
    (1 row)

I think this backslash_quote is ignored when
standard_conforming_strings is on.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

"David Gradwell" <david@gradwell.com> writes:
> set backslash_quote = off in postgresql.conf

> create table a (a1 varchar(100))
> insert into a(a1)   values ( '\602')
> gives ERROR: invalid byte sequence for encoding "UTF8": 0x82'

backslash_quote has got zero to do with that case.

            regards, tom lane