Mike Haberman wrote:
> I guess then I am curious why we have chose to use them in the first place
> for a majority of our tables.
I don't understand what you mean. Which of the existing primary keys
are in your opinion surrogate?
> I disagree with your arguement for not using them (there are other valid
> reasons why some don't like them, but the mutliple entries problem is
> easily avoided).
>
> You can avoid, (AND SHOULD do so!), multiple entries by putting a unique
> constraint on the columns in question (the ones that did make up the pkey).
> No error checking is ever done/or needed by the user.
I don't understand what specific benefits will result of adding auto
increment style
primary key columns to TURBINE_USER_GROUP_ROLE and
TURBINE_ROLE_PERMISSION tables.
Therefore, I -1 your proposal as a commiter. I will lift it only if you
really
convince me (and the others) that those keys are neccesary.
Rafal
--
Rafal Krzewski
Senior Internet Developer
mailto:[EMAIL PROTECTED]
+48 22 8534830 http://e-point.pl
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
