Re: BUG #7600: Database crash with data corruption

On 10/12/2012 09:35 PM, hankiewicz@gmail.com wrote:
> 5) after recovery was completed we have discovered that sequences on
> production database had wrong values

To follow up on Tom's explanation, if you're relying on sequences not
having "holes" then your design is dangerously mistaken. A simple
ROLLBACK throws away any IDs that were obtained from sequences in that
transaction.

If you're saying that the sequence is wrong in that it's LOWER than IDs
present in the table, then that's a problem.

--
Craig Ringer