"alter sequence" equivilant in 7.2?
Question posted by: Shea Martin
(Guest)
on
November 23rd, 2005 01:09 AM
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
2
Answers Posted
Shea Martin wrote:[color=blue]
> 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[/color]
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
Shea Martin wrote:[color=blue]
> 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[/color]
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
|
|
|
What is Bytes?
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 196,954 network members.
Top Community Contributors
|