On Sat, 4 Dec 1999, Ross J. Reedstrom wrote:
>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.
Hmmm. Thanks for the tip. It looks like I will have to dig a little deeper
into postgres.
Thank You, | http://students.washington.edu/jcwells/
Jason Wells