Darn, I was hoping for a different answer.

Just happened to run into this recently...  When I do a MOVE SET, the  
new master's sequences seem to get reset, or they were never updated  
at all.  New INSERTS get a 'duplicate key violates primary key  
constraint' message...

--Richard


On Jun 26, 2006, at 8:30 PM, cbbrowne at ca.afilias.info wrote:

>> How does slony replicate sequences?
>>
>> I am aware that slony monitors changes to tables by creating  
>> triigers on
>> each table
>> in the replication set. I see no trigger or rules for sequences  
>> that are
>> replicated.
>> How does slony keep track of sequences>
>
> Quite simply: By polling.
>
> It records current value at each SYNC...
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/slony1-general
>
>