sequences not reliable?

Поиск
Список
Период
Сортировка
От astromonk
Тема sequences not reliable?
Дата
Msg-id 37A884F2.411E3D62@flashmail.com
обсуждение исходный текст
Список pgsql-sql
rumor has it that if there is an abrupt power outage (not properly shut
down) then when the system comes back up the sequence will roll by by
1.  Is this true and has anyone seen it?

How do you fix this so this does not happen or what is the best hack?
will incrementing the sequence by 2 fix this?

Is it rolled back by "1" or rolled back 1 "value" to the previous
value?  If it were rolled back by "1" then increment by 2 would fix
things.

thanks

am
(please CC: if you post)






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

Предыдущее
От: "Stéphane FILLON"
Дата:
Сообщение: Cache lookup failed with FUNCTION + TRIGGER
Следующее
От: Kevin Sangalee
Дата:
Сообщение: Why is this sub-query select so slow?