Hi, I ran into the same "problem". Its not possible to have the same table in more then one set due to a unique constraint. Jaco
________________________________ Van: [EMAIL PROTECTED] namens [EMAIL PROTECTED] Verzonden: vr 25-1-2008 21:00 Aan: [email protected] Onderwerp: Slony1-general Digest, Vol 11, Issue 27 Send Slony1-general mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.slony.info/mailman/listinfo/slony1-general or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of Slony1-general digest..." Today's Topics: 1. problem creating a 2nd set (Geoffrey) 2. how does one 'un-init' a cluster? (Geoffrey) ---------------------------------------------------------------------- Message: 1 Date: Fri, 25 Jan 2008 10:13:52 -0500 From: Geoffrey <[EMAIL PROTECTED]> Subject: [Slony1-general] problem creating a 2nd set To: Slony List <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed 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 ------------------------------ Message: 2 Date: Fri, 25 Jan 2008 10:20:23 -0500 From: Geoffrey <[EMAIL PROTECTED]> Subject: [Slony1-general] how does one 'un-init' a cluster? To: slony <[email protected]> Message-ID: <[EMAIL PROTECTED]> Content-Type: text/plain; charset=ISO-8859-1; format=flowed I don't know if that makes sense, but how do you undo what slonik_init_cluster does? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin ------------------------------ _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general End of Slony1-general Digest, Vol 11, Issue 27 ********************************************** This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
<<winmail.dat>>
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
