Re: Would you do this?

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

In response to

Browse pgsql-general by date

  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?