> 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?
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
In response to
pgsql-bugs by date
|Next:||From: Darcy Buskermolen||Date: 2002-10-29 16:38:55|
|Subject: Re: Bug #807: Sequence currupted on recovery after kill -9|
|Previous:||From: Magnus Enbom||Date: 2002-10-29 15:41:42|
|Subject: Wrong order of rows in result during regression test.|