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)
Список
Дерево обсуждения
Partitioning, Identity and Uniqueness (given pg 16 changes) Darryl Green <darryl.green@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) David Rowley <dgrowleyml@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) Darryl Green <darryl.green@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) David Rowley <dgrowleyml@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) "David G. Johnston" <david.g.johnston@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) "David G. Johnston" <david.g.johnston@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) Ketan Popat <ketanpostgres@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) Greg Sabino Mullane <htamfids@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) Greg Sabino Mullane <htamfids@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) "David G. Johnston" <david.g.johnston@gmail.com>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) Peter Eisentraut <peter@eisentraut.org>
Re: Partitioning, Identity and Uniqueness (given pg 16 changes) Darryl Green <darryl.green@gmail.com>
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
Дата:
От: Johnathan Tiamoh
Дата:
