pglogical icon indicating copy to clipboard operation
pglogical copied to clipboard

sequences with non-0 increment are replicated incorrectly

Open bashtanov opened this issue 4 years ago • 1 comments

The sequence cache mechanism only works reasonably with sequences incremented by 1. Otherwise, by adding the cached value it may make a value that cannot be generated on the subscriber. If increment is negative it just lags instead of being ahead.

bashtanov avatar Dec 09 '19 13:12 bashtanov

Do you have a suggested patch that cleanly fixes the issue without causing any regressions?

luss avatar Feb 18 '20 17:02 luss