pgpool2.git / summary / log / commit / refs

commit    605a925e15f683d307c07e7ff92efbc9b2c82914
Author:   Tatsuo Ishii <ishii at sraoss.co.jp>
Date:     Tue Jun 28 23:07:41 2011 +0000

    Allow time stamp rewriting to work with arbitrary expression in default
    value of a column. Before we detected anything including now() then
    simply replaced it to now(). This will lead to wrong rewriting of
    default value. for example, timezone('utc'::text, now()).
    Note that, however, this only adopts to simple queries. Extended protocols
    (for example Java, PHP PDO) or sql "PREPARE" still remain same.


 doc/pgpool-en.html | 9 +++++++--
 doc/pgpool-ja.html | 6 ++++--
 2 files changed, 11 insertions(+), 4 deletions(-)

diff --git a/doc/pgpool-en.html b/doc/pgpool-en.html
index f2a9c264f..0e029dd0a 100644
--- a/doc/pgpool-en.html
+++ b/doc/pgpool-en.html
@@ -7,7 +7,7 @@
 </head>
 
 <!-- hhmts start -->
-Last modified: Sun May  1 18:34:53 JST 2011
+Last modified: Wed Jun 29 08:06:46 JST 2011
 <!-- hhmts end -->
 
 <body bgcolor="#ffffff">
@@ -2814,7 +2814,7 @@ This is done by replacing those functions by constants fetched from master at
 query execution time.
 There are a few limitations however:
 <ul>
-<li>The calculation of temporal data in table default value is not accurate in 
+<li>In pgpool-II 3.0 or before, the calculation of temporal data in table default value is not accurate in 
 some cases. For example, the following table definition:
 <pre>
 CREATE TABLE rel1(
@@ -2828,6 +2828,11 @@ CREATE TABLE rel1(
 )
 </pre>
 <p>
+pgpool-II 3.1 or later handles these cases correctly.
+Thus the column "d1" will have tomorrow as the default value.
+However this enhancement does not apply if extended protocols(used in JDBC, PHP PDO for example) or PREPARE are used.
+</p>
+<p>
 Please note that if the column type is not a temporal one, rewriting is
 not performed. Such example:
 <pre>
diff --git a/doc/pgpool-ja.html b/doc/pgpool-ja.html
index be3b1cb6f..722807c7c 100644
--- a/doc/pgpool-ja.html
+++ b/doc/pgpool-ja.html
@@ -8,7 +8,7 @@
 <body>
 
 <!-- hhmts start -->
-Last modified: Sun Jun 12 18:17:02 JST 2011
+Last modified: Wed Jun 29 08:03:01 JST 2011
 <!-- hhmts end -->
 
 <body bgcolor="#ffffff">
@@ -2879,13 +2879,15 @@ pgpool-II 2.3$B0J9_$G$O!"%F!<%V%k$N%G%U%)%k%HCM$G$NMxMQ$b4^$a!"(BCURRENT_TIMES
 </p>
 <p>
 <ul>
-<li>DEFAULT$B$K%?%$%`%9%?%s%W$rJV$9<0$,4^$^$l$F$$$k$+$I$&$+$NH=Dj$O@53N$G$O$"$j$^$;$s!#Nc$($P(B
+<li>pgpool-II 3.1$B$h$jA0$N%P!<%8%g%s$G$O(BDEFAULT$B$K%?%$%`%9%?%s%W$rJV$9<0$,4^$^$l$F$$$k$+$I$&$+$NH=Dj$O@53N$G$O$"$j$^$;$s!#Nc$($P(B
 <pre>
 CREATE TABLE rel1(
   d1 date DEFAULT CURRENT_DATE + 1
 )
 </pre>
 $B$N$h$&$J$b$N$b8=:_$N%?%$%`%9%?%s%W$H$7$F=q$-49$($r9T$$$^$9!#(B
+pgpool-II 3.1$B0J9_$G$O!"3HD%%W%m%H%3%k$H(BPREPARE$B0J30$N>l9g$K$3$NE@$,2~A1$5$l$F$*$j!">e5-$NNc$K$"$k$h$&$JNc$b@5$7$/=hM}$5$l$^$9(B($B$D$^$j!"%G%U%)%k%HCM$H$7$FL@F|$NF|IU$,%;%C%H$5$l$^$9(B)$B!#(B
+
 $B$J$*!"Ns$NDj5A$,!"(B
 <pre>
 foo bigint default (date_part('epoch'::text,('now'::text)::timestamp(3) with time zone) * (1000)::double precision)


[parent: 76f0d0331107]