[pgpool-general: 5477] Re: Backslash problem with pgpool

[Tatsuo Ishii]

> From: Tatsuo Ishii <ishii at sraoss.co.jp>
>>>> But with pgpool :
>>>> 
>>>> https:\\/\\/upload.domain.tld\\/get\\/img_0320-4.jpg
>>> 
>>> Interesting. Since ordinary text types do not behave like that
>>> (behaves same as PostgreSQL), I guess there's a problem with parsing
>>> JSON syntax. I will dig into this.
>>
>> Not reproduced here.
>>
>> test=# create table t1(j json);
> 
>> CREATE TABLE
>> test=# insert into t1 values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');
>> INSERT 0 1
>> test=# select * from t1;
>>                                 j                                
>> ------------------------------------------------------------------
>> {"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}
>> (1 row)
>> 
> 
>> This is Pgpool-II 3.5 stable head.
> 
> 
> Is there a possibility the standard_conforming_strings setting of the postgresql instance has any affect here?

No, I don't think so. Because if it's off, above INSERT should warn
and result will be different.

test=# insert into t1 values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');
WARNING:  nonstandard use of escape in a string literal
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
WARNING:  nonstandard use of escape in a string literal
LINE 1: insert into t1 values('{"image_url":"https:\/\/upload.domain...
                              ^
HINT:  Use the escape string syntax for escapes, e.g., E'\r\n'.
INSERT 0 1
test=# select * from t1;
                                j                                 
------------------------------------------------------------------
 {"image_url":"https://upload.domain.tld/get/img_0320-4.jpg"}


Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp