On Monday, February 19, 2024, David G. Johnston <david.g.johns...@gmail.com> wrote:
> On Monday, February 19, 2024, Darryl Green <darryl.gr...@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.
