bumping all sequence ids in a schema

Поиск
Список
Период
Сортировка
От Mike Broers
Тема bumping all sequence ids in a schema
Дата
Msg-id CAB9893j=mF+GBs47RMZaNAU=YvZNzQmV30Q70mL19ac0S6Vo-g@mail.gmail.com
обсуждение исходный текст
Ответы Re: bumping all sequence ids in a schema  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-admin
I would like to bump all sequences in a schema by a specified increment.  Is there a stored proc or some method that is recommended? Currently I have sql that generates scripts to do this, but it seems to be an inelegant approach and before I rework it from the ground up I want to see if anyone has already done this kind of work or thinks its a wasteful pursuit for some other reason I'm overlooking.

Thanks,
Mike


В списке pgsql-admin по дате отправления:

Предыдущее
От: Lonni J Friedman
Дата:
Сообщение: Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?