From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Williams, Travis L, NPONS <tlw@att.com>
Cc: pgsql-general@postgresql.org
Subject: Re: sequence question
Date: Thu, 9 Jan 2003 20:35:20 -0800 (PST)
Message-ID: <20030109203451.K656-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <AB815D267EC31A4693CC24D234F82916034D17B2@ACCLUST02EVS1.ugd.att.com>
On Thu, 9 Jan 2003, Williams, Travis L, NPONS wrote:
> Can you manually update the last_value in a sequence? I moved some
> data around and manually put in some of the sequence numbers.. I fixed
> the problem.. but was wondering for furture reference.
You can use setval() on the sequence to change the next value generated.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, tlw@att.com
Subject: Re: sequence question
In-Reply-To: <20030109203451.K656-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox