"alter sequence" equivilant in 7.2?

Started by Shea Martinalmost 22 years ago2 messagesgeneral
Jump to latest
#1Shea Martin
shea@snowsquirrel.ca

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

#2Shea Martin
shea@snowsquirrel.ca
In reply to: Shea Martin (#1)
Re: "alter sequence" equivilant in 7.2?

Shea Martin wrote:

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