2012/4/19 Chris Angelico <ros...@gmail.com> > > As a side point, I would recommend against doing this. Once you've > "used" a rowid, it's not worth reusing it. You'll save yourself some > headaches down the track if you simply ignore those odd gaps (ditto > the gaps that result from rolled-back transactions) and just DELETE > the rows you're throwing out without bothering to setval the sequence > back. >
Yes, for sure, however, i did this kind of workaround, because one time I've seen a rowid of 8, after an insertion even if the max(rowid) was of 42. -- Yvon