That would tend to make sense given the results I am seeing. I am/was
just paranoid that I've lost data - but everything says not an that its
just a blip in the sequencing.
On Tue, 2008-04-15 at 12:50 +0200, Emil Obermayr wrote:
> Maybe its because the sequence gets a batch of IDs in the cache and
> discards it with a crash? So unused sequence-ID get lost, while the
> sequence is reset to the number of the last really used ID during a
> normal shutdown?
> Just a thought.
In response to
pgsql-novice by date
|Next:||From: Steve T||Date: 2008-04-15 17:04:00|
|Subject: Re: Sequences - jumped after power failure|
|Previous:||From: Tom Lane||Date: 2008-04-15 14:58:17|
|Subject: Re: Sequences - jumped after power failure |