Re: sequence question

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: "Williams, Travis L, NPONS" <tlw(at)att(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: sequence question
Date: 2003-01-10 04:35:20
Message-ID: 20030109203451.K656-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Christian Imbeault 2003-01-10 05:05:14 PostgreSQL/PHP: transactions: how-to abstract out?
Previous Message Williams, Travis L, NPONS 2003-01-10 03:16:57 sequence question