Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >> This way, we don't need to bother with
> >> touching the sequence at all during a CREATE USER with explicit sysid.
>
> > Well, the problem is that this could still cause the reuse of a deleted
> > user, no? Wasn't that the problem we were originally trying to solve?
>
> Hmm, yeah I guess so. Okay, we do need to compare an explicit SYSID
> setting to the sequence, and bump up the sequence if it's greater.
> Annoying, but I guess there's no choice.
Yea, I wished we could have avoided it too, but at least we are removing
the sequential scan.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073