"Suvarna" <suvarnat(at)cygnus(dot)stpp(dot)soft(dot)net> writes:
> 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.
This is not a bug, it is the designed behavior. It's not really
different from the case of a number going unused because a transaction
does nextval() and then rolls back --- you cannot assume that the
sequence of used values has no holes, in any case.
regards, tom lane