Someone posted a dilemma to the pgsql-sql list today that involved many if not all of his sequences getting out of sync with their respective "serial" columns. In other words, something like "SELECT max(id) FROM sometable" yields 42, but the sequence nextval for sometable.id is currently set to 36. This is obviously bad (for reasons left as an exercise for the reader).

Full story »
credativ's picture
Created by credativ 11 years 46 weeks ago – Made popular 11 years 46 weeks ago
Category: High End   Tags:

Best karma users