sign in | join about | help | sitemap
Connecting Tech Pros Worldwide
Shea Martin's Avatar

"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's Avatar
Guest - n/a Posts
#2: Re: "alter sequence" equivilant in 7.2?

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's Avatar
Guest - n/a Posts
#3: Re: "alter sequence" equivilant in 7.2?

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
 
Not the answer you were looking for? Post your question . . .
196,954 members ready to help you find a solution.
Join Bytes.com

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.
Post your question now . . .
It's fast and it's free

Popular Articles

Top Community Contributors