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

[Tatsuo Ishii]

>> Example :
>> 
>>  INSERT INTO table (layer)
>>                 VALUES ('{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Point","coordinates »:[XXXXX,XXXXXXX]},"properties":{"author":"client","image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg","timestamp_add":1493730108}},{"type":"Feature","geometry":{"type":"Point","coordinates":[XXXXX,XXXXXXX]},"properties":{"author":"client","image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg","timestamp_add":1493730184}}]}’);
>> 
>> If the data are inserted directly in postgres :
>> https:\/\/upload.domain.tld\/get\/img_0320-4.jpg
>> 
>> 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.

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