Re: [HACKERS] log shipping and nextval sequences

2009-08-05 Thread Robert Haas
On Aug 5, 2009, at 3:25 PM, Tom Lane wrote: Leonardo Cezar writes: In warm standby system when we have a filled log segment forwarded to archiving, there is an inconsistency on standby next value sequences obtained by a call to nextval() function. e.g.: * Primary server - Create sequence s

Re: [HACKERS] log shipping and nextval sequences

2009-08-05 Thread Tom Lane
Leonardo Cezar writes: > In warm standby system when we have a filled log segment forwarded to > archiving, there is an inconsistency on standby next value sequences > obtained by a call to nextval() function. e.g.: > * Primary server > - Create sequence seq_a; > - Select nextval ( 'seq_a'); # va

[HACKERS] log shipping and nextval sequences

2009-08-05 Thread Leonardo Cezar
Hi, In warm standby system when we have a filled log segment forwarded to archiving, there is an inconsistency on standby next value sequences obtained by a call to nextval() function. e.g.: * Primary server - Create sequence seq_a; - Select nextval ( 'seq_a'); # value 1; - Log shipping; * Stand