Re: Problems with sequences

"Dave Cramer" <dave@fastcrypt.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