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 : Mon Oct 04 2004 - 22:27:31 EDT