"'Ben Grimm'" <bgrimm@zaeon.com> writes:
> On Fri, 15 Mar 2002, Tom Lane wrote:
>> What's bug #3? I don't recall a third issue.
> The problem I was seeing before is that when the postmaster was shutdown
> properly, log_cnt in the sequence record was saved with whatever value it
> had at the time.
Right, it's supposed to do that.
> So when it loaded from disk it would have a value greater
> than zero resulting in no XLogInsert until you'd exceded log_cnt calls to
> nextval.
This is the same as the post-checkpoint issue: we fix it by forcing an
XLogInsert on the first nextval after a checkpoint (or system startup).
regards, tom lane