Hi John,
A question - is "serverid" a foreign key to another table by any chance?
Andrus
On Jun 4, 2007, at 9:09 AM, John Armstrong wrote:
> Does Cayenne allow for the creation of a compound PK? I searched the
> archives and google more generally and could only find hints at this.
> The docs did not clarify either (although it was also hinted at. .I
> think, its a bit late :) ).
>
> My table looks like this:
>
> id
> name
> serverid
> status
> enabled
>
> I need to create a compound PK on name/serverid that will maintain
> uniqueness across these segments.
>
> My fallback is to create a validation that checks these before commit
> but my normal route in a non-ORM context is to let the DB enforce it
> and catch it there.
>
> Thanks!
> John-
>
This archive was generated by hypermail 2.0.0 : Mon Jun 04 2007 - 02:21:26 EDT