Home > mailing lists

Re: sequence question - Mailing list pgsql-general

From	Stephan Szabo
Subject	Re: sequence question
Date	January 10, 2003 02:35:16
Msg-id	20030109203451.K656-100000@megazone23.bigpanda.com Whole thread Raw
In response to	sequence question ("Williams, Travis L, NPONS" <tlw@att.com>)
List	pgsql-general

Tree view

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.

pgsql-general by date:

From: "Williams, Travis L, NPONS"
Date: 10 January 2003, 01:45:48
Subject: sequence question

From: Jean-Christian Imbeault
Date: 10 January 2003, 03:07:24
Subject: PostgreSQL/PHP: transactions: how-to abstract out?

Re: sequence question - Mailing list pgsql-general

Previous

Next