| Christopher Browne 2005-07-12, 9:24 am |
| Sun.betty wrote:
> My new quesion :
>
> I modify merge.sh
> MERGE SET ( ID =3D 1 , ADD ID =3D 5, ORIGIN =3D 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=3D# 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=3D# 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!?
> =D1=C5=BB=A2=C3=E2=B
7=D1G=D3=CA=CF=E4=A3
=AD=D6=D0=B9=FA=B5=D
A=D2=BB=BE=F8=
=CE=DE=C0=AC=BB=F8=D
3=CA=BC=FE=C9=A7=C8=
C5=B3=AC=B4=F3=D3=CA
=CF=E4
> <http://cn.mail.yahoo.com/?id=3D77071>=20
As per the documentation for MERGE SET...
"This request will fail if the two sets do not have /exactly/ the same
set of subscribers."
|