Re: Bug #807: Sequence currupted on recovery after kill -9

Neil Conway <neilc@samurai.com>

From: Neil Conway <neilc@samurai.com>
To: mthomp@tierfleet.com
Cc: pgsql-bugs@postgresql.org
Date: 2002-10-29T16:23:50Z
Lists: pgsql-bugs
pgsql-bugs@postgresql.org writes:
> If you create a file with an implied sequence and do a couple of
> inserts, then do a kill -9, when you start up again, the sequence
> will have a corrupted next_value field.  In the example, the value
> of last_value is 4 before the kill -9 and 34 when it comes back up.

What version of PostgreSQL is this?

Cheers,

Neil

-- 
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC