[pgsql-jp: 39970] ストアドプロシージャのトランザクション?

[小笠 剛]

$B>.3^$H?=$7$^$9!#(B

$B%9%H%"%I%W%m%7!<%8%c(B(plpgsql)$B$G(BINSERT$B$7$?9T$,(BODBC$B7PM3$G99?7!&:o=|$G$-$J$$$b(B
$B$N$,$"$j$^$9!#(B

$B!Z%9%H%"%I%W%m%7!<%8%c$N35MW![(B

OPEN cur1 FOR SELECT ...........;

loop
    FETCH cur1 INTO rec;

    INSERT INTO table..............;$B!&!&!&-!(B
end loop;

CLOSE cur1;

OPEN cur2 FOR SELECT ...........;

loop
    FETCH cur2 INTO rec;

    INSERT INTO table..............;$B!&!&!&-"(B
end loop;

CLOSE cur2;

$B!Z%9%H%"%I%W%m%7!<%8%c$N35MW(B : $B0J>e![(B

$B>e5-$N%W%m%7!<%8%c$G-!$H-"$OF1$8%F!<%V%k$K9T$rA^F~$7$F$$$^$9!#(B
$B-!$GA^F~$7$?9T$O(BODBC$B7PM3$G99?7!&:o=|$G$-$^$9$,!"-"$GA^F~$7$?9T$O!VB>$N%f!<(B
$B%6!<$,F1;~$K99?7$7$F$$$k!&!&!&!W$H%a%C%;!<%8$,=P$F99?7!&:o=|$G$-$^$;$s!#(B
$B!!$3$N$h$&$J8=>]$K$D$$$F2?$+8+<1$r$*;}$A$NJ}$,$$$i$C$7$c$C$?$i$4;XFn$$$?$@$-(B
$B$?$/$*4j$$?=$7>e$2$^$9!#(B
$B$I$&$>$h$m$7$/$*4j$$$$$?$7$^$9!#(B