On Wed, Jun 18, 2008 at 3:50 PM, Steve Clark <sclark(at)netwolves(dot)com> wrote:
>
> I realize this is certainly not the best design - but at this point in time
> it can't be changed. The table
> is rarely updated and never concurrently and is very small, typically less
> than 100 rows so there really is
> no performance impact.
Then the easiest way to renumber a table like that is to do something like:
create temp sequence myseq;
update table set idfield=nextval('myseq');
and hit enter.
and pray. :)