Fri Jan 25 07:13:52 PST 2008
- Previous message: [Slony1-general] Slony lagtime
- Next message: [Slony1-general] how does one 'un-init' a cluster?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I must be missing something here. I'll summarize so as to reduce the size of the example. I have two sets defined in a config file as follows: $SLONY_SETS = { "avldsSet" => { "set_id" => 1, "table_id" => 1, "sequence_id" => 1, "pkeyedtables" => [....], "keyedtables" => {}, "serialtables" => [], "sequences" => [....], } "nonavldsSet" => { "set_id" => 2, "table_id" => 2, "sequence_id" => 2, "pkeyedtables" => [....], "keyedtables" => {}, "serialtables" => [], "sequences" => [....], } }; So then my expectation is that I will need to run the following: slonik_create_set --config $CONFIG 1 |slonik slonik_create_set --config $CONFIG 2 |slonik Because I've defined two sets. Problem is, I received the following error when I run the second slonik_create_set: slonik_create_set --config $CONFIG 2|slonik <stdin>:16: Subscription set 2 created <stdin>:17: Adding tables to the subscription set <stdin>:18: PGRES_FATAL_ERROR select "_mwv_cluster".setAddTable(2, 2, 'public.aaccess', 'aaccess_pkey', 'Table public.aaccess with primary key'); - ERROR: Slony-I: setAddTable_int: table id 2 has already been assigned! CONTEXT: PL/pgSQL function "setaddtable" line 37 at perform The table mentioned 'aaccess' only exists in the first set. Do I misunderstand the concept of sets or the functionality of the slonik_create_set script? Thanks for any assistance. -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin
- Previous message: [Slony1-general] Slony lagtime
- Next message: [Slony1-general] how does one 'un-init' a cluster?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list