Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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.
regards, tom lane