Re: Generate user/group sysids from a sequence?

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.
        regards, tom lane