Re: Unique fields

From: Steve Wells (stwell..wnmail.net)
Date: Tue Oct 05 2004 - 01:53:02 EDT

  • Next message: Andrus Adamchik: "Re: SQL Template & Thread Safety"

    OK I've opened CAY-204 for this.

    ----- Original message -----
    From: "Andrus Adamchik" <andru..bjectstyle.org>
    To: cayenne-use..bjectstyle.org
    Date: Mon, 4 Oct 2004 22:27:26 -0400
    Subject: Re: Unique fields

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

    Andrus

    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" <mkienen..laska.net>
    > To: "Steve Wells" <stwell..wnmail.net>
    > Date: Mon, 04 Oct 2004 17:08:45 -0400
    > Subject: Re: Unique fields
    >
    > Steve Wells <stwell..wnmail.net> 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 : Tue Oct 05 2004 - 01:53:03 EDT