Re: Problems with sequences
От | Dave Cramer |
---|---|
Тема | Re: Problems with sequences |
Дата | |
Msg-id | 005501c17454$101c4e90$8201a8c0@inspiron обсуждение исходный текст |
Ответ на | Problems with sequences ("Dave Cramer" <dave@fastcrypt.com>) |
Список | pgsql-hackers |
Tom, Ok, we're long overdue for upgrading to 7.1.3 anyway, now I have a real good excuse to do it. Dave -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Friday, November 23, 2001 2:22 PM To: dave@fastcrypt.com Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Problems with sequences "Dave Cramer" <dave@fastcrypt.com> writes: > I am running PostgreSQL 7.0.3 on a linux box. > Recently we have had instances where the postmaster has 'crashed' and > it appears that the sequence numbers were not written to disk After > the postmaster restarts we have instances where there are rows in the > database with id's greater than the current sequence value. The > interesting part is that values are always different by 4? In other > words there is a row with an id 1004 and the sequence is currently > 1000? If you can reproduce this under 7.1.3 or later I'd be interested in pursuing it. 7.0 is rapidly attaining the status of "ancient history". Quite aside from plain old bug fixes, the existence of WAL in 7.1 would make a huge difference in the possible causes of such a problem. regards, tom lane
В списке pgsql-hackers по дате отправления: