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

2002-10-31 Thread Florian Weimer
Darcy Buskermolen <[EMAIL PROTECTED]> writes: > 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. The operating environment is free to kill -9 the postmaster at any time, and PostgreSQ

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

2002-10-29 Thread Bruce Momjian
Robert Hentosh wrote: > On Tue, 29 Oct 2002 [EMAIL PROTECTED] wrote: > > > Matt Thompson ([EMAIL PROTECTED]) reports a bug with a severity of 2 > > The lower the number the more severe it is. > > > > Short Description > > Sequence currupted on recovery after kill -9 > > > > Long Description > >

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

2002-10-29 Thread Tom Lane
[EMAIL PROTECTED] writes: > Sequence currupted on recovery after kill -9 > Long Description > 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

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

2002-10-29 Thread Robert Hentosh
On Tue, 29 Oct 2002 [EMAIL PROTECTED] wrote: > Matt Thompson ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > Sequence currupted on recovery after kill -9 > > Long Description > If you create a file with an implied seque

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

2002-10-29 Thread Darcy Buskermolen
On Tuesday 29 October 2002 08:23, Neil Conway wrote: > [EMAIL PROTECTED] 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_val

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

2002-10-29 Thread Neil Conway
[EMAIL PROTECTED] 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.

[BUGS] Bug #807: Sequence currupted on recovery after kill -9

2002-10-29 Thread pgsql-bugs
Matt Thompson ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Sequence currupted on recovery after kill -9 Long Description If you create a file with an implied sequence and do a couple of inserts, then do a kill -9, when you s