Re: [BUGS] Bug #797: Inaccurate in PostgreSQL 7.3b2 Developer's Guide

2002-10-29 Thread Bruce Momjian
Patch attached. SGML docs updated. Thanks. --- [EMAIL PROTECTED] wrote: > Piotr Kuczynski ([EMAIL PROTECTED]) reports a bug with a severity of 4 > The lower the number the more severe it is. > > Short Description > Inaccu

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

Re: [BUGS] Postgresql 7.2.3

2002-10-29 Thread Vincent Lim
Dear sir(s)/madam(s), I have upgraded to 7.2.3 as advised. However, I still get the following errors: DEBUG: recycled transaction log file 00DE FATAL 2: open of /var/lib/pgsql/data/pg_clog/0747 failed: No such file or directory DEBUG: server process (pid 22689) exited with exit cod