Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY

Поиск
Список
Период
Сортировка
От Jaime Casanova
Тема Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY
Дата
Msg-id AANLkTin03-GWB2R9mfWzp1tBQpFrHxv6e6fNLyhOtzas@mail.gmail.com
обсуждение исходный текст
Ответ на Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY  (Marc Cousin <cousinmarc@gmail.com>)
Ответы Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY  (Marc Cousin <cousinmarc@gmail.com>)
Список pgsql-hackers
On Wed, Nov 17, 2010 at 8:13 AM, Marc Cousin <cousinmarc@gmail.com> wrote:
>
> - Does the feature work as advertised?
>
> Yes. It works consistently, isn't fooled by savepoints or multiple serials
> in a table, or concurrent transactions
>

i haven't tested this nor readed the patch but i wondering what
happens in the presence of a prepared transaction (2PC), did you try
with concurrent transactions with different serialization levels?


--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Markus Wanner
Дата:
Сообщение: Re: changing MyDatabaseId
Следующее
От: Marc Cousin
Дата:
Сообщение: Re: Review: rollback sequence reset for TRUNCATE ... RESTART IDENTITY