=?iso-2022-jp?b?W3Bnc3FsLWpwOiAzNTc4MF0gIBskQi01ISEbKEIbJEIlLyVp?= =?iso-2022-jp?b?JTklPyE8JE46bz18JEskRCQkJEYbKEI=?=

[Masaichi Hasegawa]

$B$O$;$,$o$H$$$$$^$9!#(B
$B<j$C<h$jAa$$$N$O!"(Bdropdb$B$9$k$3$H$G$9!#(B
$B%/%i%9%?!<L>$O%"%s%@!<%9%3%"IU$-$G3JG<$5$l$F$$$^$9$N$G!":o=|$9$k$H$-$O(B

_$CLUSTER

$B$J$I$H$7$^$9!#!J(B$CLUSTER$B!'%/%i%9%?L>!K(B

$B8e$O<!$N(BSQL$BJ8$r%a%s%P!<$G<B9T$7$F$"$2$l$P$$$$$H;W$$$^$9!#(B
DROP SCHEMA _$CLUSTER CASCADE;

//Slony-I$B$N(BSerial key$B$N:o=|J}K!$O$o$j$^$;$s$G$7$?$,!"(B


2005/08/02 17:04:42, sakurai ＠ mxs.nes.nec.co.jp was wrote 

> 
> slony-$B-5!!%/%i%9%?!<$N:o=|$K$D$$$F!!65$($F$$$?$@$-$?$$$3$H$,$"$j$^$9!#(B
> 
> $B%5%s%W%k$r8+$J$,$i%/%i%9%?!<$rDj5A$7!"%G!<%b%s$rF0$+$7$F(B
> $B%l%W%j%1!<%7%g%s$K$O ＠ .8y$7$?$N$G$9$,!"%F%9%H$G$?$/$5$s(B
> $B%/%i%9%?!<$r:n ＠ .$7$F$7$^$$!"$=$l$r:o=|$7$?$$$N$G$9$,!"(B
> $BJ}K!$,$o$+$j$^$;$s!#(B
> 
> $B%X%k%W$K$O(B set drop table$B!!%3%^%s%I$r;H$&!!$H$"$C$?$N$G<!$N$h$&$K(B
> $B%W%m%0%i%`$rF0$+$7$?$N$G$9$,!"<B9T7k2L$O%(%i!<$G$7$?!#(B
> 
>  "_test161".setDropTable(1);  - ERROR:  Slony-I: setDropTable_int(): table 1 not found
> 
> 
>     
> slonik <<_EOF_
> 
> cluster name = $CLUSTER;
> 
> node 1 admin conninfo = 'dbname=$DB1 host=$HOST1 user=$RUSER';
> node 2 admin conninfo = 'dbname=$DB2 host=$HOST2 user=$RUSER';
> 
> init cluster (id = 1, comment = 'Node 1');
> 
> 
>     SET DROP TABLE ( 
>     ORIGIN = 1, 
>     ID = 1);
> 
> _EOF_
> 
> 
> $B$^$?!"(BDB$B$r$N$>$/$H!"%*!<%J!<$,(Bpgsql$B!J%G%U%)%k%H$O(Bpostgres)$B$G(B
> sl_set, sl_sequence$B!!$J$I$N%F!<%V%k$,(Bnspname=$B%/%i%9%?!<L>!!$G(B
> $B$?$/$5$s$G$-$F$$$^$9!J%F%9%H$G$?$/$5$s:n ＠ .$7$F$7$^$C$?$?$a!K(B
> $B$3$l$i$N%F!<%V%k$O!"(BCSE$B$J$I$N%D!<%k$G%j%9%H$K$O=P$F$/$k$N$G$9$,(B
> $BCf?H$r8+$h$&$H$9$k$H!"(B
> 
> SQL$B<B9TCf$K0J2<$N%(%i!<$,H/@8$7$^$7$?!#(B
> ERROR:  relation "sl_table" does not exist
> 
> $B$H$J$j$^$9!#(B
> $B$I$&$9$l$P!":n ＠ .$7$?BgNL$N%/%i%9%?!<$r:o=|$G$-$k$N$G$7$g$&$+!#(B
> $B$h$m$7$/$*4j$$$7$^$9!#(B


--
NTT SP$B8&(B OSP $BD9C+ ＠ n2m0l(B <hasegawa.masaichi ＠ lab.ntt.co.jp>