Re: Would you do this?

Поиск
Список
Период
Сортировка
От Paul Tomblin
Тема Re: Would you do this?
Дата
Msg-id 20010505185948.B8400@allhats.xcski.com
обсуждение исходный текст
Ответ на Would you do this?  ("Christian Marschalek" <cm@chello.at>)
Список pgsql-general
Quoting Christian Marschalek (cm@chello.at):
> I'm on a project that deals with a users database... Every user gets a
> id assigned. If he cancles his account, the next user to register will
> get his id. Would you do this? Or just let there be gaps between user
> ids?
>
> I guess just using a serial data type and don't care about gaps is the
> fastest way...

Depends what you're using the ids for, but I'd recycle them when you need
to recycle, not immediately.

--
Paul Tomblin <ptomblin@xcski.com>, not speaking for anybody
ALL programs are poems, it's just that not all programmers are poets.
-- Jonathan Guthrie in the scary.devil.monastery

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

Предыдущее
От: "Christian Marschalek"
Дата:
Сообщение: Would you do this?
Следующее
От: "Dave Cramer"
Дата:
Сообщение: Accounting Schema