We are facing a problem in nextval of sequence. The problem is as follows,
If the server shuts down abrupotly because of power failuar or any other cause then the sequences tend to skip few numbers. After restarting the server the nextval of sequence doest match with the last number.
-- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation 732.331.1324