On Fri, 15 Mar 2002, Tom Lane wrote: > "'Ben Grimm'" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
