On 4/23/07, Ovid <[EMAIL PROTECTED]> wrote:
> --- John Siracusa <[EMAIL PROTECTED]> wrote:
>> On 4/23/07, Ovid <[EMAIL PROTECTED]> wrote:
>>> http://tinyurl.com/26hpwz
>>>
>> What's wrong with implementing the scenario described at that URL exactly as
>> it's explained, by using multi-column foreign keys and a check constraint on
>> the subtype table(s)?
>
> My only concern was how portable the solution would be. Theoretically,
> Rose could add enough value to make it work regardless of the database.
> For example, right now, our version of MySQL silently truncates values
> not in an enum list and add the empty string into enum fields. Rose
> catches this error up front (thank god!).
How would RDBO check for a valid distributed key? To reference the
example again, would it try to run a query to confirm this CHECK
constraint?
ALTER TABLE Books ADD CONSTRAINT Books_ProductType_CK
CHECK (ProductType ='B');
It seems to me that, unless the isolation mode is set to serialized,
this is a check that cannot be made reliably from the client side.
What else could be pre-flighted?
-John
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
