Re: SERIAL type fields - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: SERIAL type fields
Date
Msg-id 20030424195304.GA23845@wolff.to
Whole thread Raw
In response to Re: SERIAL type fields  (Andrew Ayers <aayers@eldocomp.com>)
List pgsql-general
On Thu, Apr 24, 2003 at 12:43:24 -0700,
  Andrew Ayers <aayers@eldocomp.com> wrote:
>
> What I came across was that I wanted to reset the sequence number so
> that when the new records were added, they would start at number "1" and
> increase from there.

If you look at the documentation for setval, you will see that there is
an optional third argument that you can use to keep the value from
being incremented on the next nextval call.


pgsql-general by date:

Previous
From: "Vilson farias"
Date:
Subject: pl-pgsql question
Next
From: "scott.marlowe"
Date:
Subject: Re: SERIAL type fields