Wed Oct 27 06:22:05 PDT 2004
- Previous message: [Slony1-general] does slony currently do support sequences?
- Next message: [Slony1-general] does slony currently support sequences?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Tuesday October 26 2004 10:56, Jan Wieck wrote: > Sequences replicated by Slony do not follow exactly the same semantics > as tables. Each time a SYNC event is generated on the origin of data, > the current values of all sequences is recorded. because of the > difference in concurrency and visibility of changes between tables and > sequences, these recorded values might include changes to the sequence > that are not yet visible (committed) and therefore the corresponding > table data changes will not yet get replicated with that SYNC event. > Since sequences in PostgreSQL are not guaranteed to be gap free and > don't roll back, this is acceptable. The do get correctly adjusted on > switchover and they might be more advanced due to lost transactions in > the case of a failover. So they follow exactly the PostgreSQL sequence > semantics. If I'm reading you correctly, I think you're saying that sequences will be not syncronized between master and slave until failover. Is that correct? Ed
- Previous message: [Slony1-general] does slony currently do support sequences?
- Next message: [Slony1-general] does slony currently support sequences?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list