sequences not reliable?

From: astromonk <astromonk(at)flashmail(dot)com>
To: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: sequences not reliable?
Date: 1999-08-04 18:22:42
Message-ID: 37A884F2.411E3D62@flashmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

am
(please CC: if you post)

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 1999-08-04 22:07:14 Re: [SQL] Cache lookup failed with FUNCTION + TRIGGER
Previous Message Howie 1999-08-04 11:08:30 Re: [SQL] referential integrity