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 a
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 i
Can you do:
drop sequence people_id_seq
create sequence people_id_seq start 44
?
jesse kipp
"Jason C. Wells" wrote:
>
> sequence_name|last_value|increment_by|
>max_value|min_value|cache_value|is_cycled|is_called
>
>-+--++--+-+---+---
sequence_name|last_value|increment_by|
max_value|min_value|cache_value|is_cycled|is_called
-+--++--+-+---+-+-
people_id_seq| 4| 1|2147483647|1| 1|f|t
(1 row)
After I screw
