Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id BA82C475D3F for ; Thu, 9 Jan 2003 23:35:15 -0500 (EST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 4832C475D20 for ; Thu, 9 Jan 2003 23:35:15 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 4D50ED602; Thu, 9 Jan 2003 20:35:20 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 430AC5C03; Thu, 9 Jan 2003 20:35:20 -0800 (PST) Date: Thu, 9 Jan 2003 20:35:20 -0800 (PST) From: Stephan Szabo To: "Williams, Travis L, NPONS" Cc: Subject: Re: sequence question In-Reply-To: Message-ID: <20030109203451.K656-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/374 X-Sequence-Number: 35495 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.