"Henshall, Stuart - WCP" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html