bumping all sequence ids in a schema - Mailing list pgsql-admin

From Mike Broers
Subject bumping all sequence ids in a schema
Date
Msg-id CAB9893j=mF+GBs47RMZaNAU=YvZNzQmV30Q70mL19ac0S6Vo-g@mail.gmail.com
Whole thread Raw
Responses Re: bumping all sequence ids in a schema
List 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 by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade from 9.1 to 9.2 takes a really long time (compared to previous versions)?