[pgsql-jp: 40907] Re: search_path設定時のView

[Tsunezumi]

MauMau$B$5$s!"$4JV?.M-Fq$&$4$6$$$^$9!#(B


$BJ,$+$j$E$i$$$G$9$h$M!#$9$_$^$;$s!#(B
$BDj5A$OD9$/$J$k$N$G>JN,$5$;$F$/$@$5$$!#(B

 search_path = '"$user",u1,public'$B!!$G(B
u2$B$G@\B3$7$?>l9g!"(B
u2$B$K$O(BT2$B$,$J$$$N$G!"(B
 SELECT * FROM T1 INNER JOIN T2 ON $B!&!&!&(B   ----$B-!(B
$B$r<B9T$9$k$H!"(B
 SELECT * FROM u2.T1 INNER JOIN u1.T2 ON $B!&!&!&(B ----$B-"(B
$B$HF1$80UL#$K$J$k$H;W$$$^$9!#(B

$B$J$N$G!"(B
$B-!$N(BSQL$B$r$=$N$^$^(Bu1$B$N(BView$B$K$9$l$P!"-"$HF1$87k2L$,JV$C$F$/$k$@$m$&$H(B
$B;W$C$F$$$?$N$G$9$,!"$=$&$G$O$J$$$H$$$&$3$H$J$N$G$7$g$&$M!#(B

$B0JA0!"F1$84D6-$G%9%H%"%I$r:n ＠ .$7$?;~$K!"(B
u2$B$G@\B3$7$F$$$k8B$j$G$O!"(B
u1$B$N%9%H%"%I$G$b-"$N7k2L$,JV$C$F$-$F$?$H3P$($F$$$k$N$G!"(B
View$B$H%9%H%"%I$NF0$-$,L7=b$7$F$$$k$H;W$$!"(B
$B<ALd$5$;$FD:$-$^$7$?!#(B









On Wed, 31 Aug 2011 07:42:27 +0900
"MauMau" <maumau307 ＠ gmail.com> wrote:

> $B91=;$5$s(B
> 
> 
> MauMau$B$H$$$$$^$9!#(B
> 
> $B$A$g$C$HFq$7$=$&$J$4<ALd$J$N$G;d$K$O<+?.$,$"$j$^$;$s$,!"(B
> $B$3$N(BML$B$NJ}!9$N6(NO$r6D$0$?$a$K!"$b$&>/$7 ＠ 53N$J>pJs$,$"$C$?$[$&$,$h$$$h$&$J5$$,$7$^$9!#(B
> 
> 
> $B$?$H$($P!"(B
> 
> > SELECT * FROM V1
> > $B$H$9$k$H!"DL>o$G$"$l$P!"(B
> > u2.T1$B$H(Bu1.T2$B$r;2>H$9$k$O$:$J$N$G$9$,!"(B
> 
> $B$H$$$C$F$$$k$H$$$&$3$H$O!"(BU2.V1$B$r;2>H$9$k$O$:$@$H$$$C$F$$$k$N$@$H;W$$$^$9$,!"(B 
> 
> 
> > search_path = '"$user",u1,public'
> 
> $B$H$$$&>uBV$J$i!"(BU1.V1$B$r;2>H$9$k$b$N$H;W$$$^$9!#(B
> 
> $BLdBj$,H/@8$9$k$^$G$K9T$C$?@53N$JA`:n$,$o$+$k$h$&!"(B
> SET search_path$B$d(BCREATE TABLE$B!"%S%e!<$NDj5A3NG'!"(BSELECT$B$J$I(B
> $B<B9T$7$?$9$Y$F$N(BSQL$BJ8$H$=$N=PNO$r!"(Bpsql$B%3%^%s%I$G%U%!%$%k$K=PNO$7!"(B
> $B$=$NFbMF$r%a!<%kK\J8$KF~$l$?$[$&$,$h$$$H;W$$$^$9!#(B
> 
> 
> $B0J>e$G$9!#(B
> 
> ----- Original Message ----- 
> From: "Tsunezumi" <tsunezumi ＠ efficlabo.com>
> To: <pgsql-jp ＠ ml.postgresql.jp>
> Sent: Thursday, August 25, 2011 9:50 PM
> Subject: [pgsql-jp: 40898] search_path$B ＠ _Dj;~$N(BView
> 
> 
> > $B$*@$OC$K$J$j$^$9!#91=;$H?=$7$^$9!#(B
> > $B65$($F$/$@$5$$!#(B
> >
> > PostgreSQL8.4
> >
> > search_path = '"$user",u1,public'
> >
> > u1
> > $B!&(BT1($B%F!<%V%k(B)
> > $B!&(BT2($B%F!<%V%k(B)
> > $B!&(BT3($B%F!<%V%k(B)
> > $B!&(BV1(T1$B$H(BT2$B$r;2>H$7$?%S%e!<(B)
> > $B!&(BV2(T1$B$H(BT3$B$r;2>H$7$?%S%e!<(B)
> >
> >
> > u2
> > $B!&(BT1($B%F!<%V%k(B)
> > $B!&(BT2($B%F!<%V%k(B)$B!_(B
> > $B!&(BT3($B%F!<%V%k(B)
> > $B!&(BV1(T1$B$H(BT2$B$r;2>H$7$?%S%e!<(B)$B!_(B
> > $B!&(BV2(T1$B$H(BT3$B$r;2>H$7$?%S%e!<(B)
> >
> > $B>e5-$N>uBV$G!"(Bu2.T2$B$N%F!<%V%k$r:o=|$7$^$9!#(B
> > u2.V1$B$b:o=|$5$l$^$9!#(B
> >
> > SELECT * FROM V1
> > $B$H$9$k$H!"DL>o$G$"$l$P!"(B
> > u2.T1$B$H(Bu1.T2$B$r;2>H$9$k$O$:$J$N$G$9$,!"(B
> > u1.T1$B$H(Bu1.T2$B$r;2>H$7$F$7$^$$$^$9!#(B
> >
> > u1.V1$B$N%=!<%9$r8+$k$H!"(B
> > $B85!9$,(B
> > SELECT * FROM T1 INNER JOIN T2 ON $B!&!&!&(B
> > $B$@$C$?$N$,!"(B
> > SELECT * FROM u1.T1 INNER JOIN T2 ON $B!&!&!&(B
> > $B$H%S%e!<$N%=!<%9$,JQ99$5$l$F$$$^$7$?!#(B
> >
> > $B85$N%=!<%9$r(Bu1$B$KN.$7$F$bF1MM$N%9%-!<%^$,;XDj$5$l$?>uBV$K$J$C$?$N$G!"(B
> > u2$B$NJ}$G$=$N%=!<%9$r%3%s%Q%$%k$9$k$H!"85!9$N%=!<%9$N$^$^$G$K$J$j!"(B
> > $BA[Dj$N7k2L$rJV$7$^$9!#(B
> >
> > $B0x$_$K!"(Bu1.V2$B$H(Bu2.V2$B$O%9%-!<%^$,;XDj$5$l$F$$$J$$%=!<%9$N$^$^$K$J$C$F$$$^$9!#(B 
> > 
> >
> >
> > $B$3$l$O$3$&$$$&;EMM$J$N$G$7$g$&$+!)(B
> > $B$I$&$$$C$?$H$-$K$3$N$h$&$J>uBV$K$J$k$N$G$7$g$&$+!)(B
> > $BNc$($P!"(Bsearch_path$B$r ＠ _Dj$7$F$$$F!"$=$NCf$GF10l$N%F!<%V%k$,B8:_$9$k$H$-!"$J$I!#(B
> > $B$^$?!"2sHrJ}K!$,$"$l$P65$($F$/$@$5$$!#(B
> >
> > $B$h$m$7$/$*4j$$$7$^$9!#(B
> >
> >