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