On 10/12/2012 09:35 PM, [email protected] 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 -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
