=?iso-2022-jp?b?W3BncG9vbC1nZW5lcmFsLWpwOiA2NzBdICBwZ3Bvb2wbJEIt?= =?iso-2022-jp?b?NhsoQi0yLjMuMRskQiRHJE4lKCVpITwbKEIbJEIlYSVDJTshPCU4GyhC?= =?iso-2022-jp?b?KHBvcnRhbCAiIiBkb2VzIG5vdCBleGlzdCkbJEIkSyREJCQkRhsoQg==?=

[皿海 太二朗]

$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$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