Sequences - jumped after power failure

Поиск
Список
Период
Сортировка
От Steve T
Тема Sequences - jumped after power failure
Дата
Msg-id 1208247665.27471.250.camel@retsol610
обсуждение исходный текст
Ответы Re: Sequences - jumped after power failure  ("Sean Davis" <sdavis2@mail.nih.gov>)
Re: Sequences - jumped after power failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Is it possible for a whole set of sequences to suddenly 'jump'?

I have a set of claims tables that cover the claim itself, the customer, contact points etc. Yesterday there was a power failure and the server suffered an immediate power outage. When the server came back, everything seemed fine, apart from the fact that the claim related sequences had all jumped and left a gap of 33 (last was 52 before power failure, next one allocated after power failure 85). This seems consistent across all the tables related to the claim (it may be across the   tables in the database - I haven't checked all of them as yet).

Does this sound feasible and if so, what is the cause?

В списке pgsql-novice по дате отправления:

Предыдущее
От: nick
Дата:
Сообщение: Re: convert text file to database
Следующее
От: "Sean Davis"
Дата:
Сообщение: Re: Sequences - jumped after power failure