Re: Migration problem - serial fields - Mailing list pgsql-general

On Mon, 04 Mar 2002 19:57:50 -0500, Lee Harr wrote:

> SELECT setval('your_seq_name', 654); -- set higher than highest record.


Even better:

SELECT setval('your_seq_name',max(your_seq_col)) from your_table;

You can get away with max, rather than max+1, because the next call to
the sequence will generate max() plus the interval (usually 1).

--
Jeff Boes                                             vox 616.226.9550
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                      jboes@nexcerpt.com