| If I were to request a UNIQUE property in EOModeler, should this be on a per-table basis (which would set UNIQUE against the column in the underlying database), or on an EO entity (in the case of single table inheritance, you would not want the column to be UNIQUE because this may not be guaranteed between entities)?
Any thoughts?
Ian On 15/02/2006, at 10:14 AM, Ian Joyner wrote: Thanks for confirming my suspicions. I think I will submit a bug/NFR about this. Has anyone else done so?
Ian On 14/02/2006, at 5:25 PM, Robert Walker wrote: but this is like a low-level non-functional performance tuning solution, rather than being in the semantics of the model. Is there a way to set unique on a column in EOModeler?
As far as I know there is not. You will still need to do some database configuration/optimization in your database. At least that's what I've always done. -- Robert Walker
There are 10 types of people in the world, those who count in binary, and those who don't.
On Feb 14, 2006, at 1:02 AM, Ian Joyner wrote: Primary keys seem to be the only things that EOModeler counts as unique. However, I want other columns in the DB to be unique, particularly 'usercode'. I have modified this with SQL:
alter table USER column USERCODE set unique index;
but this is like a low-level non-functional performance tuning solution, rather than being in the semantics of the model. Is there a way to set unique on a column in EOModeler?
Ian Joyner Sportstec
_______________________________________________ Do not post admin requests to the list. They will be ignored. Help/Unsubscribe/Update your Subscription:
_______________________________________________ Do not post admin requests to the list. They will be ignored. Help/Unsubscribe/Update your Subscription:
_______________________________________________ Do not post admin requests to the list. They will be ignored. Help/Unsubscribe/Update your Subscription:
|
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
