sequences not reliable? - Mailing list pgsql-sql

From astromonk
Subject sequences not reliable?
Date
Msg-id 37A884F2.411E3D62@flashmail.com
Whole thread Raw
List 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)






pgsql-sql by date:

Previous
From: "Stéphane FILLON"
Date:
Subject: Cache lookup failed with FUNCTION + TRIGGER
Next
From: Kevin Sangalee
Date:
Subject: Why is this sub-query select so slow?