[pgsql-jp: 35785] Re: %9%?!<$N:o=|$K$D$$$F

[K.Tomita]

$B]/0fMM(B

$BIZED$G$9!#(B

$B!D!D$=$l$[$I>\$7$$$o$1$G$O$J$$$N$G$9$,!#(B

$B%^%K%e%"%k$K(B The full table name as described TABLE ADD KEY.
$B$H=q$$$F$"$k$N$G!V%9%-!<%^L>(B.$B%F!<%V%kL>!W$K$J$k$H;W$$$^$9!#(B


$B$9$_$^$;$s!"(B

>DB$BL>(B.$B%F!<%V%kL>(B

$B$K$9$k0U?^$,$o$+$j$^$;$s!#(B

$B!J(BDB$BL>(B=$B%9%-!<%^L>$G$"$k$J$i$P(BDB$BL>$rF~$l$F$b:n ＠ .2DG=$@$H;W$$$^$9$,!"(B
 slony$B$O(Bpublic$B%9%-!<%^$,L5$$$H(Bnode$B$r:n ＠ .$G$-$J$$0Y(B
 public$B%9%-!<%^$N:o=|$O$7$J$$$[$&$,NI$$$G$9!#(B
$B<+J,$O$3$l$G$O$^$j$^$7$?!#(Bversion1.0.5$B$G$9!#!K(B

$B3NG'$G$9$,(B
>$B%3%s%Q%$%k$,DL$j$^$;$s!#(B
$B$H$O!V(Bslonik$B%3%^%s%I$N<B9T$,=PMh$J$$!#!W$G$9$h$M!#(B

sakurai ＠ mxs.nes.nec.co.jp wrote:
> TO:$BIZED!!MM(B
> 
> $B!!$"$j$,$H$&$4$6$$$^$9!#(B
> 
> $B!!$*>\$7$$$h$&$J$N$G!"$b$&0lE@$*J9$-$7$?$$$N$G$9$,!"(B
> 
> $B!!(Btable add key$B%3%^%s%I$H(Bset add table $B%3%^%s%I$J$N$G$9$,!"(B
> $B!!(Bfully qualified name$B!!$K%F!<%V%kL>$r5-=R$9$k$5$$!"(Bpublic.$B%F!<%V%kL>(B
> $B!!$H5-=R$9$k$3$H$K$J$C$F$$$k$N$G$7$g$&$+!#(B
> $B!!$=$l$H$b!"(Bpublic$B$8$c$J$/!"(BDB$BL>(B.$B%F!<%V%kL>!!$G$b$h$m$7$$$N$G$7$g$&$+!#(B
> $B!!(B
> $B!!:#$N$H$3$m!"(Bpublic.$B%F!<%V%kL>$H$7$J$$$H!"%3%s%Q%$%k$,DL$j$^$;$s!#(B
> $B!!(B
> $B!!(B
> table add key (node id = 1, fully qualified name = 'public.member');
> set add table (set id=1, origin=1, id=1, fully qualified name = 'public.member', comment='member');
> 
> 
> 
> 
>>SlonyI$B$N%/%i%9%?!<%N!<%I:o=|$O(B
>>
>>slonik$B%3%^%s%I$K(B uninstall node()$B$r(B
>>$BEO$9$H=PMh$^$9!#(B
>>
>>$B0J2<;29M$G$9!#(B
>>
>>slonik <<_EOF_
>>cluster name = $CLUSTERNAME;
>>node 1 admin conninfo = 'dbname=$DB host=$HOST1 port=$PORT user=$RUSER';
>>node 2 admin conninfo = 'dbname=$DB host=$HOST2 port=$PORT user=$RUSER';
>>node 3 admin conninfo = 'dbname=$DB host=$HOST3 port=$PORT user=$RUSER';
>>node 4 admin conninfo = 'dbname=$DB host=$HOST4 port=$PORT user=$RUSER';
>>node 5 admin conninfo = 'dbname=$DB host=$HOST5 port=$PORT user=$RUSER';
>>
>>uninstall node(id=1);
>>uninstall node(id=2);
>>uninstall node(id=3);
>>uninstall node(id=4);
>>uninstall node(id=5);
>>_EOF_
>>
>>$B<+J,$b:G=i$N$&$A$O(BDrop Schema CASCADE$B$r(B
>>$B<B9T$7$F$^$7$?$1$I!#(B
>>
>>$B0J>e;29M$^$G$K!#(B
>>
>>
>>sakurai ＠ mxs.nes.nec.co.jp wrote:
>>
>>>$B?7LZ>l(B@$B]/0f$G$9!#(B
>>>
>>>
>>>$B$O$;$,$o$5$s$42sEz$r$"$j$,$H$&$4$6$$$^$7$?!#(B
>>>
>>>DROP SCHEMA _test165 CASCADE;
>>>
>>>$B$G8+;v$$$i$J$$%F!<%V%k$,$3$H$4$H$/>C$($^$7$?!#(B
>>>$B8aA0Cf$+$iF1$8$h$&$J$3$H$r$$$m$$$m%H%i%$$7$F(B
>>>$B$$$?$N$G$9$,!"$d$jJ}$,$$$1$J$+$C$?$N$G$7$g$&$+!#(B
>>>
>>>$B$9$C$-$j!"$5$C$Q$j$G$9!#(B
>>>
>>>slony-$B-5$O>pJs$,>/$J$/$F$J$+$J$+BgJQ$G$9$,!"(B
>>>$B$@$s$@$sF0$/$h$&$K$J$C$F$-$^$7$?!#$b$&0lB)!*!*(B
>>>
>>>
>>>
>>>
>>>
>>
> ***********************************************
> 
> $B!!]/0f!!:L;R!!!!(BSakurai$B!!(BAyako
> 
>   NEC$B%=%U%H3t<02q<R(B
> $B!!Bh0l41D#%=%j%e!<%7%g%s;v6HIt!!BhFs%7%9%F%`It(B
> 
> $B!!(BTEL$B!!(B03-5569-3225   8-141-2385
>   FAX$B!!(B03-5569-3289   141-2589
> 
> ***********************************************
> 


-- 
///////////////////////////////
//  GOURMET NAVIGATOR INC.   //
//   $B5;=Q(BDept. $B3+H/%0%k!<%W(B  //
//     Kazutaka  Tomita      //
//      tomita ＠ gnavi.co.jp   //
///////////////////////////////