On Fri, 15 Mar 2002, Tom Lane wrote:
> "'Ben Grimm'" <bgrimm@zaeon.com> writes:
> > When these bugs are fixed there is still the issue of bug #3 that I
> > came across. The one that I work around by resetting log_cnt to 0 when a
> > backend initializes a sequence. It's this third bug that made the other
> > two so apparent. Fixing them does not obviate the need to fix this one.
>
> 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. 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.
AFAICT, your patch fixes this problem, as I can't reproduce it now.
Thanks!
-- Ben