Re: Problems with sequences

Tom,

Ok, we're long overdue for upgrading to 7.1.3 anyway, now I have a real
good excuse to do it.

Dave

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, November 23, 2001 2:22 PM
To: dave(at)fastcrypt(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Problems with sequences

"Dave Cramer" <dave(at)fastcrypt(dot)com> writes:
> I am running PostgreSQL 7.0.3 on a linux box.
> Recently we have had instances where the postmaster has 'crashed' and
> it appears that the sequence numbers were not written to disk After
> the postmaster restarts we have instances where there are rows in the
> database with id's greater than the current sequence value. The
> interesting part is that values are always different by 4? In other
> words there is a row with an id 1004 and the sequence is currently
> 1000?

If you can reproduce this under 7.1.3 or later I'd be interested in
pursuing it. 7.0 is rapidly attaining the status of "ancient history".
Quite aside from plain old bug fixes, the existence of WAL in 7.1 would
make a huge difference in the possible causes of such a problem.

regards, tom lane