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

yum yum @ ishina.net
2011年 9月 3日 (土) 03:20:16 JST


$B%S%e!<$N:n @ .<T$,JQ$o$C$F$$$^$;$s$+!)(B


  CREATE VIEW u1.v1 AS
  SELECT * FROM t1 INNER JOIN t2 ON $B!D(B;

$B$NMM$J7A$G%S%e!<$r:n @ .$9$k$H!"(B
$B%f!<%6!<(Bu2$B$G%S%e!<$r:n @ .$9$k$N$H!"B>$N%f!<%6!<$G:n @ .$9$k$N$G$O!"(B
$B%S%e!<$,;2>H$9$k%F!<%V%k$,JQ$o$k$O$:$G$9$,!#(B

-----------
$B$f$`(B

$B"-"-"-"-"-"-"-"-"-(B Original Message $B"-"-"-"-"-"-"-"-"-(B
From:    Tsunezumi <tsunezumi @ efficlabo.com>
To:      PostgreSQL Japanese Mailing List <pgsql-jp @ ml.postgresql.jp>
Date:    Fri, 02 Sep 2011 23:52:36 +0900
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
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 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
> > >
> > >
> 
$B",",",",",",",",(B Original Message Ends$B",",",",",",",",(B


pgsql-jp メーリングリストの案内