Re: sequence increment jumps?
От
Douglas McNaught
Тема
Re: sequence increment jumps?
Дата
Msg-id
873b5zgfgq.fsf@suzuka.mcnaught.org
Ответ на
sequence increment jumps? (John Smith)
Список
Дерево обсуждения
sequence increment jumps? "John Smith" <jayzee.smith@gmail.com>
Re: sequence increment jumps? Bruno Wolff III <bruno@wolff.to>
Re: sequence increment jumps? Douglas McNaught <doug@mcnaught.org>
Re: sequence increment jumps? Benjamin Smith <lists@benjamindsmith.com>
Re: sequence increment jumps? Douglas McNaught <doug@mcnaught.org>
Re: sequence increment jumps? Bruce Momjian <bruce@momjian.us>
Re: sequence increment jumps? "Merlin Moncure" <mmoncure@gmail.com>
"John Smith" 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
В списке pgsql-general по дате отправления
