Jason -
Jesse's sugestion should work, but there's a setval() function for
this exact use:
SELECT setval('people_id_seq',44);
I usually use it like this:
SELECT setval('"Experiments_ExptID_seq"',max("ExptID")) from "Experiments";
That automatically sets the sequence value to the current max in the table.
Ross
--
Ross J. Reedstrom, Ph.D., <reedstrm(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005