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

[Tsunezumi]

MauMau$B$5$s!"$f$`$5$s$4JV?.M-Fq$&$4$6$$$^$9!#(B
$BJV?.CY$/$J$j$9$_$^$;$s!#(B

$B3N$+$K!"0MB84X78$+$i$$$/$H;d$,4|BT$7$?F0$-$O$G$-$J$$$O$:$G$9$M!#(B
$B%9%H%"%I$,$=$N$h$&$JF0$-$r$7$F$$$?$H5-21$7$F$$$?$N$G:.Mp$7$F$7$^$$$^$7$?!#(B

$B3F!9$K%S%e!<$r$D$/$k$3$H$GBP1~$7$^$7$?!#(B

$BM-Fq$&$4$6$$$^$7$?!#(B







On Sat, 3 Sep 2011 13:40:55 +0900
"MauMau" <maumau307 ＠ gmail.com> wrote:

> $B91=;$5$s(B
> 
> 
> MauMau$B$G$9!#(B
> 
> $B%d%`$5$s$N$*$C$7$c$k$h$&$K!"%f!<%6(Bu1$B$H(Bu2$B$N$I$A$i$,%S%e!<$r:n ＠ .$9$k$+$K$h$C$F!"(B 
> 
> $B%S%e!<$,;2>H$9$k%F!<%V%k$,0[$J$k$O$:$G$9!#(B
> 
> $B$I$&$$$&$3$H$+$H$$$&$H!";2>H$5$l$k%F!<%V%k$O%S%e!<$N:n ＠ .;~$K3NDj$9$k$H$$$&$3$H$G$9!#(B
> $B91=;$5$s$,4|BT$7$?$3$H$O!"%S%e!<$KBP$7$FLd$$9g$o$;$r<B9T$9$k$H$-$N(B
> $B%9%-!<%^8!:w%Q%9$K1~$8$F!";2>H$5$l$k%F!<%V%k$,JQ$o$k$H$$$&$3$H$@$H;W$$$^$9!#(B
> $B$b$7$=$&$@$H$9$k$H!"$?$H$((BSELECT$BJ8$G(Bu1.v1$B$N$h$&$K%9%-!<%^$rL@<#$7$F$b!"(B
> $B$=$N(BSELECT$BJ8$r<B9T$7$?%;%C%7%g%s$N%9%-!<%^8!:w%Q%9$K$h$C$F!"(B
> $BLd$$9g$o$;$N7k2L$,JQ$o$C$F$7$^$$$^$9!#(B
> u1.v1$B$H$$$&$h$&$K;2>H$9$k%*%V%8%'%/%H$rL@<#$7$?$K$b$+$+$o$i$:!"$G$9!#(B
> $B$3$l$O:$$j$^$9$M!#(B
> 
> $B$^$?!"91=;$5$s$N4|BT$7$??6$kIq$$$O!"%F!<%V%k$H%S%e!<$N4V$N(B
> $B0MB8 ＠ -$N4QE@$+$i$b:$$C$?$3$H$K$J$j$^$9!#(B
> $B%S%e!<$,;2>H$9$k%F!<%V%k$r:o=|$9$k$H!"(BDBMS$B$O$=$N%F!<%V%k$K0MB8$7$?%S%e!<$b$$$C$7$g$K:o=|$7$F$/$l$^$9$h$M!#(B
> $B$3$l$,2DG=$JM}M3$O!"!V$I$N%9%-!<%^$N$I$N%F!<%V%k!W$K0MB8$7$F$$$k$N$O(B
> $B!V$I$N%9%-!<%^$N$I$N%S%e!<!W$+$,5-O?$5$l$F$$$F$o$+$k$+$i$G$9!#(B
> 
> $B91=;$5$s$N4|BT$K4p$E$/$H!"(Bu1.v1$B$,!"(B
> u1.t1$B$H(Bu1.t2$B$K0MB8$9$k$N$+!"(B
> $B$=$l$H$b(B
> u2.t1$B$H(Bu2.t2$B$K0MB8$9$k$N$+!"(B
> $B$,3NDj$G$-$J$/$J$j$^$9!#(B
> 
> $B$=$N$?$a!"Ev=i$KNW$s$@%S%e!<$rF@$k$K$O!"(B
> $B%f!<%6(Bu1$B$H(Bu2$B$,$=$l$>$l!"%9%-!<%^(Bu1$B$H(Bu2$B$K(B
> $B%S%e!<$r:n ＠ .$9$kI,MW$,$"$k$H;W$$$^$9!#(B
> 
> $B0J>e$G$9!#(B
> 
> ----- Original Message ----- 
> From: "Tsunezumi" <tsunezumi ＠ efficlabo.com>
> To: "PostgreSQL Japanese Mailing List" <pgsql-jp ＠ ml.postgresql.jp>
> Sent: Friday, September 02, 2011 11:52 PM
> Subject: [pgsql-jp: 40907] Re: search_path$B ＠ _Dj;~$N(BView
> 
> 
> > 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
> >