Re: Would you do this? - Mailing list pgsql-general

From Ludwig Meyerhoff
Subject Re: Would you do this?
Date
Msg-id Pine.LNX.4.21.0105060109490.24253-100000@ludwig
Whole thread Raw
In response to Would you do this?  ("Christian Marschalek" <cm@chello.at>)
List pgsql-general
Hallo!

> 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?
Well, AFAIK it is not a good idea to use IDs again, as by doing this You
have to be absolutely sure the application You run does not save some data
separately (login data, history and so on) ...
As You write the application to acces Your database it should not be of
that interest, but what if Your collegue (or the customer) decides to
write a new frontend?
But if You delete a row froma table, the following rows should move one
up, shouldn't they?


Saluti!

Ludwig


pgsql-general by date:

Previous
From: "Dave Cramer"
Date:
Subject: Accounting Schema
Next
From: GH
Date:
Subject: Re: Accounting Schema