<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Yes, i’m using <div class="">replication_mode = on<br class=""><div class=""><br class="webkit-block-placeholder"></div><div class="">I don’t have time for the moment for the streaming replication</div><div class="">I need to have 3 or more servers with automatic failover and i need to have at least 2 servers in the pool. </div><div class="">According to the documentation that I started to look at, I have to put automatically the slaves back on the new master if the master fail.</div><div class=""> </div></div><div class="">I will try to work on it next week if my client leaves me a maintenance range.</div><div class="">
<div style="color: rgb(0, 0, 0); font-family: Helvetica; font-size: medium; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class=""><br class="Apple-interchange-newline">Cordialement, </div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class=""><br class=""></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class="">Sébastien Gay</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class="">L'équipe Support</div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class=""><br class=""></div><div style="color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: -webkit-auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; " class="">-- <br class="">OVEA<br class="">Tél. : 04 67 67 00 00<br class=""><a href="http://www.ovea.com" class="">http://www.ovea.com</a><br class=""></div>
</div>
<br class=""><div><blockquote type="cite" class=""><div class="">Le 18 mai 2017 à 11:14, Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" class="">ishii@sraoss.co.jp</a>> a écrit :</div><br class="Apple-interchange-newline"><div class=""><div style="" class=""><blockquote type="cite" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Hello<br class=""><br class="">Thank you for your answers<br class="">I think their 2 bugs :<br class="">- The backslash problem<br class="">- A cache problem<br class=""><br class="">I’m using Debian Jessie with postgres 9.5.6 and postgis 2.3<br class="">Pgpool 3.5.6<br class=""><br class="">When i’m doing your test, no problem but if a date column is added, you can reproduce the problem :<br class=""><br class="">Your test :<br class=""><br class="">postgres=# create table t1(j json);<br class="">CREATE TABLE<br class="">postgres=# insert into t1 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">INSERT 0 1<br class="">postgres=# select * from t1 ;<br class=""> j <br class="">------------------------------------------------------------------<br class="">{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}<br class="">(1 ligne)<br class=""><br class="">Now, i’m creating a new table with a date column<span class="Apple-converted-space"> </span><br class=""><br class=""><br class="">postgres=# create table t2(j json, "date" timestamp(6) WITH TIME ZONE DEFAULT now());<br class="">CREATE TABLE<br class="">postgres=# insert into t2 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">INSERT 0 1<br class="">postgres=# select * from t2;<br class=""> j | date <br class="">----------------------------------------------------------------------+-------------------------------<br class="">{"image_url":"https:\\/\\/upload.domain.tld\\/get\\/img_0320-4.jpg"} | 2017-05-17 09:30:34.864892+02<br class="">(1 ligne)<br class=""><br class="">We have the backslash problem<br class=""></blockquote><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Did not reproduced here. Are you using native replication mode?</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">(replication_mode = on). I am in streaming replication mode. If yes,</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">that might be a bug with timestamp rewriting code in native</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">replication mode.</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">test=# create table t3(j json, "date" timestamp(6) WITH TIME ZONE DEFAULT now());</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">CREATE TABLE</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">test=# insert into t3 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">INSERT 0 1</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">test=# select * from t3;</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class=""> j | date </span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">------------------------------------------------------------------+-------------------------------</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"} | 2017-05-18 18:08:16.728585+09</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">(1 row)</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><blockquote type="cite" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class=""><br class="">Now, I’m dropping the table and i create a new table without the date column<span class="Apple-converted-space"> </span><br class=""><br class=""><br class="">postgres=# DROP TABLE IF EXISTS t2 ;<br class="">DROP TABLE<br class="">postgres=# create table t2(j json);<br class="">CREATE TABLE<br class="">postgres=# insert into t2 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">ERROR: column "date" of relation "t2" does not exist<br class="">LIGNE 1 : insert into t2 (j) values('{"image_url":"https:\/\/upload.d...<br class=""> ^<br class="">postgres=# select * from t2 ;<br class="">j<span class="Apple-converted-space"> </span><br class="">---<br class="">(0 ligne)<br class=""><br class="">Their no date column, i’m think it’s the cache problem<span class="Apple-converted-space"> </span><br class=""></blockquote><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><span style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Yes, I think so too. See "relcache_expire" in pgpool.conf.</span><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><br style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px;" class=""><blockquote type="cite" style="font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Now i’m creating a new table without the date column<span class="Apple-converted-space"> </span><br class=""><br class="">No problem<span class="Apple-converted-space"> </span><br class=""><br class=""><br class="">postgres=# create table t3(j json);<br class="">CREATE TABLE<br class="">postgres=# insert into t3 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">INSERT 0 1<br class="">postgres=# select * from t3 ;<br class=""> j <br class="">------------------------------------------------------------------<br class="">{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}<br class="">(1 ligne)<br class=""><br class=""><br class="">I’m dropping the table and i’m creating it with a date column<span class="Apple-converted-space"> </span><br class=""><br class=""><br class="">postgres=# DROP TABLE IF EXISTS t3;<br class="">DROP TABLE<br class="">postgres=# create table t3(j json, "date" timestamp(6) WITH TIME ZONE DEFAULT now());<br class="">CREATE TABLE<br class="">postgres=# insert into t3 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">INSERT 0 1<br class="">postgres=# select * from t3;<br class=""> j | date <br class="">------------------------------------------------------------------+-------------------------------<br class="">{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"} | 2017-05-17 09:33:24.879886+02<br class="">(1 ligne)<br class=""><br class=""><br class="">In this case, no problem<span class="Apple-converted-space"> </span><br class=""><br class="">I’m closing the pgpool connection and i reopen it<span class="Apple-converted-space"> </span><br class=""><br class="">With the t1 table, the problem occurs<span class="Apple-converted-space"> </span><br class=""><br class="">postgres=# insert into t1 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">INSERT 0 1<br class="">postgres=# select * from t1 ;<br class=""> j | date <br class="">----------------------------------------------------------------------+-------------------------------<br class="">{"image_url":"https:\\/\\/upload.domain.tld\\/get\\/img_0320-4.jpg"} | 2017-05-17 09:34:12.233069+02<br class="">{"image_url":"https:\\/\\/upload.domain.tld\\/get\\/img_0320-4.jpg"} | 2017-05-17 09:42:19.329917+02<br class="">(2 lignes)<br class=""><br class=""><br class="">And with the t3 table, we have the problem<span class="Apple-converted-space"> </span><br class=""><br class="">postgres=# insert into t3 (j) values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">INSERT 0 1<br class="">postgres=# select * from t3 ;<br class=""> j | date <br class="">----------------------------------------------------------------------+-------------------------------<br class="">{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"} | 2017-05-17 09:33:24.879886+02<br class="">{"image_url":"https:\\/\\/upload.domain.tld\\/get\\/img_0320-4.jpg"} | 2017-05-17 09:42:33.932703+02<br class="">(2 lignes)<br class=""><br class=""><br class=""><br class="">Regards,<span class="Apple-converted-space"> </span><br class=""><br class="">Sébastien Gay<br class="">L'équipe Support<br class=""><br class="">--<span class="Apple-converted-space"> </span><br class="">OVEA<br class="">Tél. : 04 67 67 00 00<br class=""><a href="http://www.ovea.com" class="">http://www.ovea.com</a><br class=""><br class=""><blockquote type="cite" class="">Le 16 mai 2017 à 18:20, Tatsuo Ishii <ishii@sraoss.co.jp> a écrit :<br class=""><br class=""><blockquote type="cite" class="">From: Tatsuo Ishii <ishii@sraoss.co.jp><br class=""><blockquote type="cite" class=""><blockquote type="cite" class=""><blockquote type="cite" class="">But with pgpool :<br class=""><br class="">https:\\/\\/upload.domain.tld\\/get\\/img_0320-4.jpg<br class=""></blockquote><br class="">Interesting. Since ordinary text types do not behave like that<br class="">(behaves same as PostgreSQL), I guess there's a problem with parsing<br class="">JSON syntax. I will dig into this.<br class=""></blockquote><br class="">Not reproduced here.<br class=""><br class="">test=# create table t1(j json);<br class=""></blockquote><br class=""><blockquote type="cite" class="">CREATE TABLE<br class="">test=# insert into t1 values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">INSERT 0 1<br class="">test=# select * from t1;<br class=""> j <br class="">------------------------------------------------------------------<br class="">{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}<br class="">(1 row)<br class=""><br class=""></blockquote><br class=""><blockquote type="cite" class="">This is Pgpool-II 3.5 stable head.<br class=""></blockquote><br class=""><br class="">Is there a possibility the standard_conforming_strings setting of the postgresql instance has any affect here?<br class=""></blockquote><br class="">No, I don't think so. Because if it's off, above INSERT should warn<br class="">and result will be different.<br class=""><br class="">test=# insert into t1 values('{"image_url":"https:\/\/upload.domain.tld\/get\/img_0320-4.jpg"}');<br class="">WARNING: nonstandard use of escape in a string literal<br class="">HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.<br class="">WARNING: nonstandard use of escape in a string literal<br class="">LINE 1: insert into t1 values('{"image_url":"https:\/\/upload.domain...<br class=""> ^<br class="">HINT: Use the escape string syntax for escapes, e.g., E'\r\n'.<br class="">INSERT 0 1<br class="">test=# select * from t1;<br class=""> j <br class="">------------------------------------------------------------------<br class="">{"image_url":"https://upload.domain.tld/get/img_0320-4.jpg"}<br class=""><br class=""><br class="">Best regards,<br class="">--<br class="">Tatsuo Ishii<br class="">SRA OSS, Inc. Japan<br class="">English: http://www.sraoss.co.jp/index_en.php<br class="">Japanese:http://www.sraoss.co.jp</blockquote></blockquote></div></div></blockquote></div><br class=""></body></html>