I can't tell what a roll is based on your question, but here is how to
set a sequence to a specific value.
SELECT setval('foo', 42); Next nextval will return 43
http://www.postgresql.org/docs/8.4/interactive/functions-sequence.html
-Randall
On Mon, 2010-08-23 at 05:04 -0500, SUNDAY A. OLUTAYO wrote:
> How can I reset a sequence column due to deletion of some rolls?
>
> Sunday Olutayo
> Sadeeb Technologies Ltd
>