See setval(), nextval(), and currval() in the documentation on how to modify
sequences on the fly.
Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"
> From: "mike" <matrix(at)quadrent(dot)net>
> Date: Fri, 5 Oct 2001 15:07:10 -0400
> To: <pgsql-general(at)postgresql(dot)org>
> Subject: [GENERAL] resequencing an existing sequence
>
>
> I'm currently working on an online application that uses a sequence to
> order the layout of blocks of text, but I've come to a problem when
> someone adds blocks of text between existing blocks. I'm wondering if there
> is any way to resequence an existing sequence to accommodate the new blocks
> of text.
>
> Mike