Re: Bug #807: Sequence currupted on recovery after kill -9 - Mailing list pgsql-bugs

From Neil Conway
Subject Re: Bug #807: Sequence currupted on recovery after kill -9
Date
Msg-id 877kg12oyx.fsf@mailbox.samurai.com
Whole thread Raw
In response to Bug #807: Sequence currupted on recovery after kill -9  (pgsql-bugs@postgresql.org)
Responses Re: Bug #807: Sequence currupted on recovery after kill -9  (Darcy Buskermolen <darcy@wavefire.com>)
List 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

pgsql-bugs by date:

Previous
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #807: Sequence currupted on recovery after kill -9
Next
From: Darcy Buskermolen
Date:
Subject: Re: Bug #807: Sequence currupted on recovery after kill -9