pgpool2.git / summary / log / commit / refs

commit    6228daea0aaa006c97b66ebd77546bc5fbfd5f1a
Author:   Yoshiyuki Asaba <y-asaba at pgfoundry.org>
Date:     Fri May 25 02:37:11 2007 +0000

    Add handling "SELECT nextval".


 doc/pgpool-en.html |  1 +
 doc/pgpool-ja.html | 11 +++++++++--
 2 files changed, 10 insertions(+), 2 deletions(-)

diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index eb3ab89e6..91a4ffd34 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -674,6 +674,7 @@ For the query to be load balanced, all the requirements below
 	<li>PostgreSQL version 7.4 or later</li>
 	<li>the query must not be in the explicitly declared
 	    transaction (i.e. not in a BEGIN ~ END block)</li>
+    <li>it's not SELECT nextval or SELECT setval
     <li>it's not SELECT INTO
     <li>it's not SELECT FOR UPDATE
     <li>start with "SELECT" (ignore_leading_white_space = true will
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index cfa9ee115..c179b72d8 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -690,14 +690,21 @@ load_balance_mode = true $B$r@_Dj$7$?>l9g!$0J2<$N>r7o$rK~$?$7$?;~$KLd$$(B
 <li>PostgreSQL$B$N%P!<%8%g%s$,(B7.4$B0J9_(B
 <li>$BLd$$9g$o$;$,L@<(E*$J%H%i%s%/%6%7%g%s%V%m%C%/$NFbB&$K$J$$(B($B$D$^$j!$(B
        BEGIN$B$rH/9T$7$F$$$J$$(B)
-<li>SELECT $BJ8(B
+<li>SELECT $BJ8(B($B$?$@$7!"(BSELECT nextval $B$H(B SELECT setval $B$N>l9g$O=|$/(B)
 <li>SELECT INTO $BJ8$G$O$J$$(B
 <li>SELECT FOR UPDATE $BJ8$G$O$J$$(B
 <li>$B%/%(%jJ8;zNs$,(B SELECT $B$G;O$^$k(B(ignore_leading_white_space = true
     $B$N>l9g$O6uGr$OL5;k$7$^$9(B)
 </ul>
 
-$B>e5-$rK~$5$J$$>l9g$O$9$Y$F$N%P%C%/%(%s%I$K%/%(%j$rAw?.$7$^$9!#(B
+$B>e5-$rK~$5$J$$>l9g$O(B SELECT $B0J30$N%/%(%j$r%P%C%/%(%s%I$KAw?.$7$^$9!#$b(B
+$B$7(B SELECT $B$r%l%W%j%1!<%7%g%s$5$;$?$$>l9g$O(B
+
+<pre>
+  /*REPLICATION*/ SELECT ...
+</pre>
+
+$B$H!"(BSELECT $B$NA0$K%3%a%s%H$rIU$1$F$/$@$5$$!#(B
 </p>
 
 <h4>$B%l%W%j%1!<%7%g%s%b!<%I$K$*$1$k=LB`1?E>$K$D$$$F(B</h4>


[parent: ad2fb68fa387]