Re: BUG #7600: Database crash with data corruption

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: hankiewicz(at)gmail(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #7600: Database crash with data corruption
Date: 2012-10-13 11:10:54
Message-ID: 50794C3E.3070608@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 10/12/2012 09:35 PM, hankiewicz(at)gmail(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2012-10-13 11:55:11 Re: BUG #7595: terminate process in an unusual way
Previous Message Craig Ringer 2012-10-13 10:55:17 Re: Sorry to bother you. Please tell me exactly how the compiler was built ODBC