Re: Reset sequence to current maximum value of rows

> company_nbr | company_name -------------+-------------------------------------------------
> 1 | Markowitz Herbold PC
> 2 | Markowitz Herbold PC
> 3 | Markowitz Herbold PC
> 4 | Markowitz Herbold PC
> 5 | Markowitz Herbold PC
> 6 | Markowitz Herbold PC
> 7 | Markowitz Herbold PC
> 8 | Markowitz Herbold PC
> 9 | Markowitz Herbold PC
> 10 | Markowitz Herbold PC
> 11 | Markowitz Herbold PC
> 12 | Markowitz Herbold PC
> 13 | Markowitz Herbold PC
> 14 | Markowitz Herbold PC
> 15 | Markowitz Herbold PC
> 16 | Markowitz Herbold PC
> 17 | Markowitz Herbold PC
> 18 | Markowitz Herbold PC
> 19 | Markowitz Herbold PC
> 20 | Markowitz Herbold PC
> 22 | Markowitz Herbold PC
> 23 | Markowitz Herbold PC
> --More--

Did those rows contain these values in some earlier transaction in your data-entry process perhaps? I’m thinking that perhaps you overwrote them in a later transaction with the correct values for the names, but forgot to commit that transaction?

It’s either that, or you did run an UPDATE statement against those rows without specifying a WHERE-clause, as others already suggested as a likely cause.

I think we can rule out the possibility of index corruption (a very rare occurrence, usually caused by factors external to PG) for your case. A data-set this limited would most likely result in an execution plan using a sequential scan instead of an index scan (an EXPLAIN ANALYZE of above select statement would show proof).

> It might be quicker for me to restore the entire database from that backup
> and then insert all new table rows since I have saved all the scripts.

If you end up in the same situation again after doing that, then you know at least it’s repeatable and can analyse how you got there.

Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.