Hmm... is this even a PK generation question? I understand that "id"
is a unique PK already? Is there a need to define name/serverid as a
part of PK as well? I mean you can (and Cayenne will support it), but
what's the point. Maybe instead you can define a UNIQUE constraint on
those two columns in your table?
Andrus
On Jun 4, 2007, at 9:25 AM, John Armstrong wrote:
Yes, sorry misplaced that bit of important information.
ImapServer
account
id
password
serverip
Tx
John-
On 6/3/07, Andrus Adamchik <[EMAIL PROTECTED]> wrote:
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-
>
