On Sat, 2002-09-28 at 00:17, Gavin King wrote: > Yes, well you see that was my understanding also. My reading of that > statement is that the identity column *on its own* is a unique key of the > table (whether theres a UNIQUE constraint or not). > > So a primary key constraint that includes an identity column is actually an > *error* in the relational model. The other columns are redundant.
Yes, they're redundant in the relational sense. But I don't think they are in the performance sense which is one reason I believe they're used. (I'm a little more curious about this now and will probably bug someone about it on Monday.) But I'm not a database guy, just a developer :-) Chris ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
