Re: [HACKERS] [BUGS] Bug #613: Sequence values fall back to previously chec

2002-03-19 Thread Dave Cramer
I noticed a message asking if this scenario was consistent with the other reports, and yes it is. We have seen this occuring on our system with versions as old as 7.0. Glad to see someone has finally nailed this one. Dave ---(end of broadcast)---

Re: [HACKERS] [BUGS] Bug #613: Sequence values fall back to previously

2002-03-15 Thread Bruce Momjian
Tom Lane wrote: > 2. I renamed XLogCtl->RedoRecPtr to SavedRedoRecPtr, and renamed > the associated routines to SetSavedRedoRecPtr/GetSavedRedoRecPtr, > in hopes of reducing confusion. Good. > 3. I believe it'd now be possible to remove SavedRedoRecPtr and > SetSavedRedoRecPtr/GetSavedRedoRecPtr

Re: [HACKERS] [BUGS] Bug #613: Sequence values fall back to previously

2002-03-15 Thread Bruce Momjian
Tom Lane wrote: > Attached is a patch against current CVS that fixes both of the known > problems with sequences: failure to flush XLOG after a transaction > that only does "SELECT nextval()", and failure to force a new WAL > record to be written on the first nextval after a checkpoint. > (The lat

Re: [HACKERS] [BUGS] Bug #613: Sequence values fall back to previously chec

2002-03-14 Thread Tom Lane
"Dave Cramer" <[EMAIL PROTECTED]> writes: > I noticed a message asking if this scenario was consistent with the > other reports, and yes it is. We have seen this occuring on our system > with versions as old as 7.0. Given that these are WAL bugs, they could not predate 7.1.