[pgsql-jp: 30459] SynonymによるTBL切替について。

[Ken Nakajima]

$B$O$8$a$^$7$F(B $B%J%+%8%^!wHSED66(B $B$G$9!#(B

Oracle$B$G(Bsynonym$B$rMxMQ$7$F(BTBL$B$r ＠ Z$jBX$($F$$$?(BDB$B$r(BPostgresql$B$K0\9T$7$h$&$H(B
$B;W$C$F$*$j$^$9!#(B
$B$J$K$+$$$$:n ＠ o$O$"$j$^$9$G$7$g$&$+!)(B
$B$4B8CN$NJ}$,$$$i$C$7$c$$$^$7$?$i$4;Y1g4j$$$^$9!#(B

$B!&(Bsynonym$B$K$h$k(BTBL$B ＠ ZBX(B

$B%a%s%F%f!<%6(B
 UserA
 UserB
$B$N(B2$B$D$N%f!<%6$G8rBX$K(BTBL$B$N%a%s%F$r9T$C$F$$$^$9!#(B

$B;2>H%f!<%6(B(AP$B$O$3$A$i$N%f!<%6$rMxMQ(B)
 UserC
$B$KBP$7$F:G?7$N(BTBL$B$r(BSynonym$B$G ＠ Z$jBX$($FDs6!$7$F$$$^$9!#(B

ex:
$B!&:rF|(B
UserA.TBLXXX <- UserA $B$,%a%s%F(B
UserB.TBLXXX <- $B;2>HMQ$K(Bsynonym$B%j%s%/(B -> UserC.TBLXXX
UserC.TBLXXX = UserB.TBLXXX <- UserC$B$,;2>H(B

$B!&F|<!=hM}(B
UserC.TBLXXX $B$r(B UserB.TBLXXX $B"*(B UserA.TBLXXX $B$K ＠ ZBX(B
UserA.TBLXXX $B$+$i(B UserB.TBLXXX $B$rF14|(B
$B"(!'@Z$jBX$($kM}M3$O%a%s%F;~4V$NC;=L$N$?$a!#(B

$B!&:#F|(B
UserA.TBLXXX <- $B;2>HMQ$K(Bsynonym$B%j%s%/(B -> UserC.TBLXXX
UserB.TBLXXX <- UserB $B$,%a%s%F(B
UserC.TBLXXX = UserA.TBLXXX <- UserC$B$,;2>H(B

()()
($B!&(Bx)
Ken Nakajima
knakajima ＠ addo.co.jp