Christopher Browne wrote:
> Alan Hodgson <ahodgson at simkin.ca> writes:
>> On Monday 09 June 2008, Geoffrey <lists at serioustechnology.com> wrote:
>>> I've got a number of sequences that are to be replicated in our
>>> databases.  I understand that sequences are special one row tables, but
>>> I don't see any triggers on my master node sequences that would cause
>>> the values to be replicated.
>>>
>>> How is this handled in Slony?
>> I believe it just copies over the current sequence values on every sync, but 
>> I could be wrong. Obviously, they have to be part of the replication set 
>> for this to happen.
> 
> They are essentially handled via polling; every time a SYNC is
> processed, we pull all of the replicated sequence values.
> 
> In v2.0, the values get pulled each time; we only pass on an update
> when the sequence actually changes.

So then I assume that I don't need to worry about replication_role 
values with regard to replicating sequences, since there are no triggers 
involved.


-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin