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(at)nexcerpt(dot)com