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

[Glyn Astill]

_______________________________
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?