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

[Gavin K. <ga...@ap...>]

> IDENTITY fields in MS SQL (and Sybase, for that matter) are very simple:
> there can be only one IDENTITY field per table, and every INSERT is
> guaranteed to generate a unique value for that field.

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.