[pgsql-jp: 40818] スキーマ間のトリガー

[Tsunezumi]

$B$*@$OC$K$J$j$^$9!#91=;$H?=$7$^$9!#(B

$B%H%j%,!<$,$&$^$/$$$+$J$$$N$G!"<ALd$5$;$F$/$@$5$$!#(B
Windows,Postgresql8.4.8

1$B$D$N(BDB$B$KF19=@.$N%9%-!<%^$rFs$DMQ0U$7$^$9!#(B(S1,S2)
$B$b$H$b$H#1$D$N%9%-!<%^$G=hM}$5$l$k$h$&$K$J$C$F$$$^$9!#(B
$B%F!<%V%k(BA$B!"%F!<%V%k(BB$B!"%9%H%"%I(BC$B!"%F!<%V%k(BD$B$,N>J}$N%9%-!<%^$K$"$j$^$9!#(B

S1$B$K%F!<%V%k(BA$B$r4F;k$9$k%H%j%,!<$r:n ＠ .$7!"(B
$B%F!<%V%k(BA$B$,99?7$5$l$l$P!"(BS2$B$N%F!<%V%k(BB$B$r99?7$7!"(B
S2$B$K$"$k%9%H%"%I(BC$B$r<B9T$7!"(BS2$B$N%F!<%V%k(BB$B$r85$K(BS2$B$N%F!<%V%k(BD$B$r99?7$7$?$$$H9M$($F$$$^$9!#(B

$B$^$:$7$?$3$H$G$9$,!"(B
$B-!(BS1$B$K%F!<%V%k(BA$B$r4F;k$9$k%H%j%,!<(BE$B$r:n ＠ .$7$^$7$?!#(B
$B-"%H%j%,!<(BE$B$G;HMQ$9$k%9%H%"%I(BF$B$r(BS1$B$K:n ＠ .$7$^$7$?!#(B
$B!!%9%H%"%I(BF$B$O(BS2$B$N%F!<%V%k(BB$B$r99?7$7!"(BS2$B$K$"$k%9%H%"%I(BC$B$r<B9T$9$k%W%m%0%i%`$G$9!#(B

$B>e5-$r<B9T$9$k$H!"(B
S2$B$N%F!<%V%k(BB$B$^$G$O99?7$5$l$k$N$G$9$,!"(BS2$B$N%F!<%V%k(BD$B$O99?7$5$l$^$;$s!#(B
$B$3$l$O%H%j%,!<(BE$B$,(BS1$B$K$"$k$?$a!"(BS2$B$N%9%H%"%I(BC$B$,(BS1$B$N%F!<%V%k$r8+$K$$$C$F$7$^$C$F$$$k$h$&$G$7$?!#(B


$B<!$K$7$?$3$H$,!"(B
$B-!(BS1$B$K%F!<%V%k(BA$B$r4F;k$9$k%H%j%,!<(BE$B$r:n ＠ .$7$^$7$?!#(B
$B-"%H%j%,!<(BE$B$G;HMQ$9$k%9%H%"%I(BF$B$r(BS1$B$K:n ＠ .$7$^$7$?!#(B
$B!!%9%H%"%I(BF$B$O(BS2$B$N%F!<%V%k(BB$B$r99?7$9$k%W%m%0%i%`$G$9!#(B
$B-#(BS2$B$K%F!<%V%k(BB$B$r4F;k$9$k%H%j%,!<(BG$B$r:n ＠ .$7$^$7$?!#(B
$B-$%H%j%,!<(BG$B$G;HMQ$9$k%9%H%"%I(BH$B$r(BS2$B$K:n ＠ .$7$^$7$?!#(B
$B!!%9%H%"%I(BH$B$O(BS2$B$K$"$k%9%H%"%I(BC$B$r<B9T$9$k%W%m%0%i%`$G$9!#(B

$B$3$N9=@.$r<B9T$7$F$b!">e$HF1MM%F!<%V%k(BD$B$O99?7$5$l$^$;$s!#(B


$B7k6I$O%9%H%"%I(BC$B$K%9%-!<%^$r;XDj$9$kI,MW$,$"$k$N$G$7$g$&$+!)(B


$B$h$m$7$/$*4j$$$7$^$9!#(B