From: | Paul Tomblin <ptomblin(at)xcski(dot)com> |
---|---|
To: | "[GENERAL] PostgreSQL" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Would you do this? |
Date: | 2001-05-05 22:59:48 |
Message-ID: | 20010505185948.B8400@allhats.xcski.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Quoting Christian Marschalek (cm(at)chello(dot)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(at)xcski(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2001-05-05 23:09:13 | Accounting Schema |
Previous Message | Christian Marschalek | 2001-05-05 22:39:20 | Would you do this? |