"John Smith" <jayzee.smith@xxxxxxxxx> writes: > i had insert errors yesterday ("ERROR: invalid input syntax for > integer" "ERROR: column 'columnname' is of type date but expression is > of type integer") but they didn't cause any increment jumps. and when > i insert a record now the sequence increments just fine. > > bug or nature of the beast? how to reset? btw using 8.1, got no other > sessions, no record deletes, no triggers, no rules. Nature of the beast. Sequence increments aren't rolled back on transaction abort (for performance and concurrency reasons), so you should expect gaps. -Doug