On Tue, Apr 15, 2008 at 4:21 AM, Steve T <steve@[EMAIL PROTECTED]
> wrote:
>
> Is it possible for a whole set of sequences to suddenly 'jump'?
>
> I have a set of claims tables that cover the claim itself, the
customer,
> contact points etc. Yesterday there was a power failure and the server
> suffered an immediate power outage. When the server came back,
everything
> seemed fine, apart from the fact that the claim related sequences had
all
> jumped and left a gap of 33 (last was 52 before power failure, next one
> allocated after power failure 85). This seems consistent across all the
> tables related to the claim (it may be across the tables in the
database -
> I haven't checked all of them as yet).
>
> Does this sound feasible and if so, what is the cause?
One explanation: if there were uncommitted transactions at the time of
the power failure, the sequence would have been advanced, but the
corresponding rows would not have entered the database.
Sean
--
Sent via pgsql-novice mailing list (pgsql-novice@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
|
