=?iso-2022-jp?b?W3BncG9vbC1nZW5lcmFsLWpwOiA2NzFdIFJlOiBwZ3Bvb2wb?= =?iso-2022-jp?b?JEItNhsoQi0yLjMuMRskQiRHJE4bKEIbJEIlKCVpITwlYSVD?= =?iso-2022-jp?b?JTshPCU4GyhCKHBvcnRhbCAiIiBkb2VzIG5vdCBleGlzdCkb?= =?iso-2022-jp?b?JEIkSyREJCQbKEIbJEIkRhsoQg==?=

ISHIDA Akio iakio @ mono-space.net
2010年 1月 12日 (火) 19:03:21 JST


$B$3$s$K$A$O!#@PED(B@$BFQ>.KR;T$H?=$7$^$9!#(B

2010$BG/(B1$B7n(B7$BF|(B22:04 $B;.3$!!B @ FsO/(B <saragai @ mbgx.tis.co.jp>:
> $B;.3$(B($B%5%i%,%$(B)$B$H?=$7$^$9!#(B
> $BD9J8$H$J$j?=$7Lu$4$6$$$^$;$s$,!"$43NG'$$$?$@$1$^$;$s$G$7$g$&$+!#(B
>
> pgpool$B-6(B-2.3.1$B$,%j%j!<%9$5$l$?$H$*J9$-$7!"(B
> pgpool$B-6(B-2.2.6$B$+$i(B2.3.1$B$X%P!<%8%g%s%"%C%WCW$7$^$7$?!#(B
>
> $B$=$3$G!"(Boperatioin_log$B$H$$$&%F!<%V%k$KBP$7!"(B
> $B0J2<$N(BSQL$B$r<B9T$7$?:]$K!"(Bpostgresql$B$N%m%0$K%(%i!<$,=PNO$5$l$F$*$j$^$9!#(B
>
> $B!Z<B9T(BSQL$BJ8![(B
> $sql = 'insert into operation_log
> (session_id,user_id,event_date,log_text,user_name) values
> (:session,12345,NOW(),:log,:user)';
> $stmt = $dbh->prepare($sql);
> $stmt->bindValue(':session', 'shimada_test');
> $stmt->bindValue(':log', '20100107$B%F%9%H(B');
> $stmt->bindValue(':user', '20100107$BEgED(B');
> $flag = $stmt->execute();
>
> $B!Z(Bpostgresql$B%5!<%P%m%0(B($B%P%C%/%(%s%I%5!<%P$bF1MM$N%m%0M-(B)$B![(B
> 2010-01-07 15:40:22 JST:17216 ERROR: bind message has 3 parameter
> formats but 4 parameters
> 2010-01-07 15:40:22 JST:17216 STATEMENT: INSERT INTO
> "operation_log"("session_id", "user_id", "event_date", "log_text",
> "user_name") VALUES ($1,12345,"timestamptz"($4::text),$2,$3)
> 2010-01-07 15:40:22 JST:17216 ERROR: portal "" does not exist
> 2010-01-07 15:40:22 JST:17216 ERROR: portal "" does not exist
>
> $B$3$A$i!"(Bnow()$B4X?t$r(B"timestamptz"($4::text)$B$KJQ49$7$F(BINSERT$B$9$k$3$H$K$h$k(B
> $B%(%i!<$G$"$k$H9M$($F$*$j$^$9!#(B
>
> $B;v>]$NH/@8860x$O(Bpgpool$B$N%P!<%8%g%s%"%C%W$K$h$k$b$N$H(B
> $B9M$($F$*$j!"%P%0$N5?$$$b$"$k$H9M$($F$*$j860x$rD4::$$$?$@$/$3$H$O2DG=$G(B
> $B$7$g$&$+!#(B
>

$B$O$$!#(Bpgpool$B$N%P%0$G$9!#$9$$$^$;$s8+Mn$H$7$F$^$7$?!#(B

$B>e$N%3!<%I$O(BPHP$B$N(BPDO$B$K$h$k$b$N$H;W$$$^$9$,!"(B
- $B%?%$%`%9%?%s%W$N=q$-49$($,H/@8$9$k%1!<%9$G(B
- PQprepare$B$J$I$G(BparamFormats$B$r;XDj$5$l$?>l9g$G!"(B
- $B85$N%/%(%j$K(B2$B$D0J>e$N%Q%i%a!<%?$,B8:_$9$k>l9g$K(B
$BH/@8$9$k$h$&$G$9!#(B

$B$H$j$"$($:$4Js9p$^$G!#(B
$B=$@5$K$O$b$&>/!9$*;~4V$r$/$@$5$$!#(B


> $B$J$*>e5-$N%(%i!<$O!"(Bpostgres$B%5!<%P$KD>@\@\B3$7!"(B
> SQL$BJ8$r<B9T$7$?>l9g$K$O=PNO$5$l$^$;$s!#(B
>
> $BB>$N>pJs$K$D$$$F$O0J2<$NDL$j$G$9!#(B
> //$B!Z%F!<%V%k$N%+%i%`Dj5A![(B
> publis=# \d operation_log
> Table "public.operation_log"
> Column | Type | Modifiers
> ---------------------+--------------------------+---------------
> page_id | integer |
> share_id | integer |
> article_id | integer |
> block_id | integer |
> function_block_type | smallint |
> session_id | character varying(4000) |
> user_id | integer |
> event_date | timestamp with time zone | default now()
> log_text | character varying(4000) |
> title | character varying(4000) |
> user_name | character varying(4000) |
> Indexes:
> "operation_log_event_idx" btree (event_date)
> "operation_log_page_idx" btree (page_id, article_id, block_id)
> "operation_log_share_idx" btree (share_id)
>
> $B!Z(Bpostgresql$B$N%P!<%8%g%s![(B
> 8.3.7
>
> $B0J>e!"$h$m$7$/$*4j$$CW$7$^$9!#(B
>
> _______________________________________________
> pgpool-general-jp mailing list
> pgpool-general-jp @ sraoss.jp
> http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp
>
>



-- 
ISHIDA Akio <iakio @ mono-space.net/ishida @ cycleof5th.com>


pgpool-general-jp メーリングリストの案内