Re: Unique fields

From: Andrus Adamchik (
Date: Mon Oct 04 2004 - 22:27:26 EDT

  • Next message: Andrus Adamchik: "Re: Unique fields"

    I agree - Cayenne should support UNIQUE constraints in one form or
    another. Could someone open an issue in JIRA please?


    On Oct 4, 2004, at 9:24 PM, Steve Wells wrote:

    > Yes Mike, that sounds a winner, I guess I just wanted to be ultra-lazy
    > and get Cayenne to manage that. I like the idea of being to mark
    > things
    > as an index. Originally I was just thinking of UNIQUE CONSTRAINT or
    > UNIQUE INDEX (SQL Server terms) but getting Cayenne to manage all index
    > types would be nice, though I'm not sure how possible this is
    > x-database. maybe something for V2.x ;)
    > ----- Original message -----
    > From: "Mike Kienenberger" <>
    > To: "Steve Wells" <>
    > Date: Mon, 04 Oct 2004 17:08:45 -0400
    > Subject: Re: Unique fields
    > Steve Wells <> wrote:
    >> I think it would be nice to be able to flag a set of columns that
    >> would
    >> make each row unique (for insert), much like using natural keys. This
    >> is a lazy way of saying, I dont want to have to check if a set of
    >> field
    >> values exist in the table before I insert.
    > You can generally specify this in the database using indexes (at least
    > for
    > Oracle and OpenBase). Of course, since it's a lazy method, it'll just
    > throw
    > database exceptions on problems.
    > It might be nice to see the ability to specify indexing from the
    > modeler.
    > Andrus, if you have OpenBaseManager installed, the UI for doing that
    > there
    > is pretty cool. You just pull-down "no index", "index", "unique
    > index",
    > "clustered index", etc, for each db attribute.
    > Not sure how well supported this is across databases.

    This archive was generated by hypermail 2.0.0 : Mon Oct 04 2004 - 22:27:31 EDT