| Sun.betty 2005-07-12, 3:24 am |
|
very very Thanks for answer of Christopher Browne . about merge I happen new question and error . If anybody know,Please help me.
[color=darkred]
>Christopher Browne answer for :
>
>It seems reasonably clear in the documentation.
>
>For MERGE SET...
>
>ID = ival indicates the set to contain the union of the two separate sets.
>
>If you plan to merge sets 1 and 2 together to get a new set 1, then "ID = 1"
>
>ADD ID = ival indicates the unique id of the set whose objects should be
>transferred. That would be set #2.
>
>ORIGIN is the current origin node for both sets; that appears to be node#1.
>
My new quesion :
I modify merge.sh
MERGE SET ( ID = 1 , ADD ID = 5, ORIGIN = 1 );
purpose is : merge set 1 add set 5 to set 1 .
but exex merge.sh show errors:
bash-2.03$ ./merge.sh
<stdin>:4: PGRES_FATAL_ERROR select "_test1".mergeSet(1, 5); - ERROR: Slony-I: subscriber lists of set 1 and 5 are different
look system table :
test=# select * from _test1.sl_set ;
set_id | set_origin | set_locked | set_comment
--------+------------+------------+---------------------
1 | 1 | | All pgbench tables
2 | 1 | | All pgbench tables
3 | 1 | | All pgbench tables
4 | 1 | | All pgbench tables
5 | 1 | | add tb_test3 tables
(5 rows)
test=# select * from _test1.sl_table ;
tab_id | tab_reloid | tab_relname | tab_nspname | tab_set | tab_idxname | tab_altered | tab_comment
--------+------------+-------------+-------------+---------+----------------------------------+-------------+----------------
1 | 319045 | accounts | public | 1 | accounts_pkey | t | accounts table
2 | 319037 | branches | public | 1 | branches_pkey | t | branches table
3 | 319041 | tellers | public | 1 | tellers_pkey| t | tellers table
4 | 419364 | history | public | 1 | history__Slony-I_test1_rowID_key | t | history table
5 | 547522 | tb_test1 | public | 2 | pk_tb_test1 | t | tb_test1 table
6 | 548223 | tb_test2 | public | 4 | pk_tb_test2 | t | tb_test2 table
7 | 580442 | tb_test3 | public | 5 | pk_tb_test3 | t | tb_test3 table
(7 rows)
what reason lead show this error ? if you know please,give some tip for me .Thanks very much !
---------------------------------
DO YOU YAHOO!?
ÑÅ»¢Ãâ·ÑGÓÊÏä£_Öйúµ
ÚÒ»¾øÎÞÀ¬»øÓʼþɧÈų
¬´óÓÊÏä
|