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

On Tuesday 29 October 2002 08:23, Neil Conway wrote:
> 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.

I'm sure if you read the footers on Tom's email's it's pretty clearly stated 
'do not kill -9 the postmaster'. 
So I'm not so sure that this is really a bug. 

-- 
Darcy Buskermolen
Wavefire Technologies Corp.
ph: 250.717.0200
fx:  250.763.1759
http://www.wavefire.com