jason at buberel.org jason at buberel.org
Wed May 16 11:48:04 PDT 2007
Thank you for the kindly RTFM :)

To quote from the documentation: This ID must be unique across all sets; you 
cannot have two tables in the same cluster with the same ID.

Which leads me to ask whether or not either of the following two statements 
are true of slony:

Within a single cluster, a table can only be a member of one set.

- or -

Within a single cluster, a table can be a member of more than one set as 
long as each of those sets has the same origin node.

Thanks,
jason


Andrew Sullivan writes:

> On Tue, May 15, 2007 at 05:42:43PM -0500, jason at buberel.org wrote:
>> One more quick/easy question:
>> 
>> Given that I have one table that would appear in several sets (named 
> 
> No, it won't.  A table must appear in exactly one set.
> 
> If you want that table to appear on three members, then you put it in
> the all_members set.  If you want a table to appear only on the foo
> member, then you put it in the foo_members set.  If you want it to
> appear on (say) foo and bar but not baz, then you put it in the
> foobar_members set.  Something like that.  I think you need to
> re-read the manual about sets.
> 
> A
> 
> -- 
> Andrew Sullivan  | ajs at crankycanuck.ca
> When my information changes, I alter my conclusions.  What do you do sir?
> 		--attr. John Maynard Keynes


More information about the Slony1-general mailing list