Re: Partitioning, Identity and Uniqueness (given pg 16 changes)

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Partitioning, Identity and Uniqueness (given pg 16 changes)
Дата
Msg-id CAKFQuwZ1D3to93Jy_R5xhotbugh0auTbfagRBOO+HBRFKGH77w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Partitioning, Identity and Uniqueness (given pg 16 changes)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения


On Monday, February 19, 2024, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Monday, February 19, 2024, Darryl Green <darryl.green@gmail.com> wrote:

> It may be possible to still have it work by doing a speculative record
> in the index for the target table then go and check all of the other
> indexes before marking the speculative entry as valid.

It is always valid - except in the OVERRIDING SYSTEM VALUE case - no?

 False.

ALTER TABLE … ALTER id RESTART 1;

Even without a reset as soon as you override system value at least one future non-override insert is going to fail when the sequence catches up to whatever that non-overridden value was.

David J.

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Partitioning, Identity and Uniqueness (given pg 16 changes)
Следующее
От: Johnathan Tiamoh
Дата:
Сообщение: DETAIL: Could not open file "pg_xact/0EEA": No such file or directory