Horton
Menu

Re: After ~Crash Sequence not correct

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Henshall, Stuart - WCP" <SHenshall@westcountrypublications.co.uk>
Cc: "'pgsql-bugs@postgresql.org'" <pgsql-bugs@postgresql.org>, Vadim Mikheev <vmikheev@sectorbase.com>
Date: 2001-12-19T16:02:53Z
Lists: pgsql-bugs 
"Henshall, Stuart - WCP" <SHenshall@westcountrypublications.co.uk> writes:
> Setup: PostgreSQL 7.1.2 on Dual PIII WinNT4 server + Cygwin 1.3.2
> PostgreSQL is run as a service and when rebooting (which doesn't shutdown -
> previously on cygwin list (hence the ~Crash in title)) I have twice noticed
> that a sequence was not properly updated, however records with Primary keys
> based upon the sequence where present in the table.

Hmm.  You're about the third person to report something like this, so
there's clearly something not right.  I'm guessing a bug in the WAL
logging or redo code for sequences ...

			regards, tom lane