Add a version number column, so PK will be these 3 columns e.g.
VERSION_NO INTEGER,
MAID ,
GMID
Jan
>
> Translation:
>
> Tricky question to databases:
>
> We have tables with a composite primary key; eg. maid, gmid.
> Sofar so good.
>
> Now suppose, from this table records should not be physically deleted, but
> flaged as deleted by an additional field GELOESCHT. Is the field 0, then
> the record is not deleted, else the timestamp (date and time) of the deletion
> is in the field. Now the primary key no longer works, because there could be
> several records with the same MAID and GMID. Including GELOESCHT in the PK
> would be possible in theory, but dangerous (since it's a float and who
> knows if 0 always equals 0...).
>
> =====================================================================
>
> After reading this I had to run off, so I let others step in.
>
> Please do not crosspost!
>
> =====================================================================
>
> Bitte nicht cross-posten!
>
> Holger
Received on Thu Oct 02 2003 - 08:41:05 CDT
