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