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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org