Alan Hodgson <[EMAIL PROTECTED]> writes: > On Monday 09 June 2008, Geoffrey <[EMAIL PROTECTED]> 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. -- select 'cbbrowne' || '@' || 'linuxfinances.info'; http://linuxdatabases.info/info/nonrdbms.html I found out why cats drink out of the toilet. My mother told me it's because it's cold in there. And I'm like: How did my mother know THAT? --Wendy Liebman _______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
