Обсуждение: Rollback sequence reset on TRUNCATE rollback patch

Поиск
Список
Период
Сортировка

Rollback sequence reset on TRUNCATE rollback patch

От
Steve Singer
Дата:
The attached patch modifies TRUNCATE ... RESTART IDENTITY so that if the
transaction rolls back the restart of the sequence will also be rolled back.

It follows the general outline discussed at
http://archives.postgresql.org/pgsql-hackers/2008-05/msg00550.php of
assigning a new reffilenode to the sequence.


I will add this to the next commitfest.


Steve

Вложения

Re: Rollback sequence reset on TRUNCATE rollback patch

От
Tom Lane
Дата:
Steve Singer <ssinger@ca.afilias.info> writes:
> The attached patch modifies TRUNCATE ... RESTART IDENTITY so that if the 
> transaction rolls back the restart of the sequence will also be rolled back.

Applied with significant editorialization (didn't much like the
refactoring you'd chosen for DefineSequence, and there were some
other issues).
        regards, tom lane