Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
