<p>Hi, all</p>
<p>I'm checking pgpool behavior and documented behavior.<br>Mainly, I run regression test included PostgreSQL 9.1.1.<br>I have some questions.</p>
<p>===================================<br>1. behavior about PREPARE statement<br>===================================</p>
<p>When I execute PREPARE statement on standby PostgreSQL, <br>any response is not back to the client.</p>
<p>I've executed query espected becoming error like bellow.<br> # PREPARE q4(nonexistenttype) AS select $1;</p>
<p>Is this same behavior with [pgpool-general: 99] bug ?</p>
<p><br>=============================================<br>2. behavior about standard_conforming_strings<br>=============================================</p>
<p>When I execute escape strings via pgpool, <br>the result is difference from one executed on PostgreSQL.<br>before executing the query, I changed 'standard_conforming_strings' parameter<br>to off.<br> # SET standard_conforming_strings TO off;</p>
<p>this is the query.<br> # select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\' as f4, 'ab\\\'cd' as f5, '\\\\' as f6;</p>
<p>---------------------------------------------------------------------------------<br>testdb=# select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\' as f4, 'ab\\\'cd' as f5, '\\\\' as f6;<br>
WARNING: nonstandard use of \\ in a string literal<br>LINE 1: select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3,...<br> ^<br>HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br>
WARNING: nonstandard use of \\ in a string literal<br>LINE 1: select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3,...<br> ^<br>HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br>
WARNING: nonstandard use of \\ in a string literal<br>LINE 1: select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3,...<br> ^<br>
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br>WARNING: nonstandard use of \\ in a string literal<br>LINE 1: ...bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\' ...<br>
^<br>HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br>WARNING: nonstandard use of \\ in a string literal<br>LINE 1: ...'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\' as f4, 'ab\\\'cd'...<br>
^<br>HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br>WARNING: nonstandard use of \\ in a string literal<br>LINE 1: ...'''cd' as f3, 'abcd\\' as f4, 'ab\\\'cd' as f5, '\\\\' as ...<br>
^<br>HINT: Use the escape string syntax for backslashes, e.g., E'\\'.<br> f1 | f2 | f3 | f4 | f5 | f6 <br>-------+--------+---------+-------+--------+----<br>
a\bcd | a\b'cd | a\b''cd | abcd\ | ab\'cd | \\<br>(1 row)<br>---------------------------------------------------------------------------------</p>
<p>via pgpool, the result is bellow.</p>
<p>---------------------------------------------------------------------------------<br>testdb=# select 'a\\bcd' as f1, 'a\\b\'cd' as f2, 'a\\b\'''cd' as f3, 'abcd\\' as f4, 'ab\\\'cd' as f5, '\\\\' as f6;<br>
Invalid command \. Try \? for help.<br>---------------------------------------------------------------------------------</p>
<p><br>========================================<br>3. documentation about DECLARE statement<br>========================================<br>current document says like bellow, <br>----<br>These queries can be sent to both the primary node and the standby node. <br>
If load balancing is enabled, these types of queries can be sent to the <br>standby node. <br>However, if delay_threshold is set and the replication delay is higher <br>than delay_threshold, queries are sent to the primary node. </p>
<p>SELECT not listed above <br>COPY TO <br>DECLARE, FETCH, CLOSE <br>SHOW <br>----</p>
<p>on the other hand, "Release Note" in Japanese document says that<br>pgpool-II 2.2.6 had been changed NOT to do load balancing with <br>DECLARE, CLOSE, FETCH and MOVE statements.</p>
<p><br>which is rigth ?</p>
<p><br>regards,<br>-------------------<br>Tomonari Katsumata<br></p>