Re: Secuence not updated

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jesus Sandoval <meli(at)mzt(dot)megared(dot)net(dot)mx>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Secuence not updated
Date: 2001-11-18 19:59:29
Message-ID: 4338.1006113569@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jesus Sandoval <meli(at)mzt(dot)megared(dot)net(dot)mx> writes:
> maybe the problem was becase somebody reset the computer without doing a
> shutdown.

Is that speculation, or do you know that someone actually did that shortly
before you noticed the problem?

I seem to recall one other report of a sequence apparently losing a few
counts during a crash, so we may have something to look into here. But
we need the clearest description you can give us of the events you
observed.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jesus Sandoval 2001-11-18 23:01:18 Re: Secuence not updated
Previous Message Jesus Sandoval 2001-11-18 18:54:57 Secuence not updated