Sun.betty wrote:

> 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???????????????????
> <http://cn.mail.yahoo.com/?id=77071> 

As per the documentation for MERGE SET...

"This request will fail if the two sets do not have /exactly/ the same
set of subscribers."