Re: Sequence reset

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "SUNDAY A(dot) OLUTAYO" <olutayo(at)sadeeb(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sequence reset
Date: 2010-08-23 10:19:33
Message-ID: AANLkTimsAvt18GefnS0-STU8kG8SuhAwBPRrzcWvWSWK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Aug 23, 2010 at 4:04 AM, SUNDAY A. OLUTAYO <olutayo(at)sadeeb(dot)com> wrote:
> How can I reset a sequence column due to deletion of some rolls?

Note that a design of a column that holds the output of a sequence and
can't handle gaps is pretty much broken.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-08-23 13:30:39 Re: disappearing data
Previous Message Magnus Hagander 2010-08-23 10:15:28 Re: disappearing data