On Wed, Jun 18, 2008 at 3:50 PM, Steve Clark <sclark@xxxxxxxxxxxxx> 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. :)