sequence not reliable? - Mailing list pgsql-general

From Ramanika
Subject sequence not reliable?
Date
Msg-id 37A79678.715237CA@flashmail.com
Whole thread Raw
List pgsql-general
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

r
(please CC: if you post)


pgsql-general by date:

Previous
From: Thomas Lim
Date:
Subject: Data type recommendation
Next
From: Ramanika
Date:
Subject: referential integrity