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, [EMAIL PROTECTED] 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 > [email protected] > http://gborg.postgresql.org/mailman/listinfo/slony1-general > > _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
