Re: Generate user/group sysids from a sequence?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Generate user/group sysids from a sequence?
Дата
Msg-id 13145.1042824965@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Generate user/group sysids from a sequence?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: Generate user/group sysids from a sequence?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Generate user/group sysids from a sequence?  (Ketrien Saihr-Kenchedra <ksaihr@error404.nls.net>)
Список pgsql-hackers
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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Generate user/group sysids from a sequence?
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Generate user/group sysids from a sequence?