I am moving my database from a machine running 7.4 to a machine running 7.2. My sequences are not out of wack, is there a way to set the current value of a sequence? I though ALTER SEQUENCE would work but it does not exist in version 7.2.
Thanks,
~S
I honestly did to google before posting the above. But couldn't find anything. But I just found this, which did exactly what I wanted:
SOLUTION:
select setvalue('post_id_seq', 234134);
~S
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
