Re: "alter sequence" equivilant in 7.2?

Поиск
Список
Период
Сортировка
Искать

Re: "alter sequence" equivilant in 7.2?

От:
Shea Martin <shea@snowsquirrel.ca>
Дата:
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
FAQ