Re: [Hibernate] generated field as part of composite key

[Chris W. <cwi...@op...>]

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