"John Smith" <jayzee.smith@gmail.com> 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