--- John Siracusa <[EMAIL PROTECTED]> wrote: > 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?
I was thinking of a rather complicated query that would select data from all of the distributed tables (at once, rather than iteratively) and return the table name if one and only one had the required data. It turns out to be tricky for me to write, though :) Cheers, Ovid -- Buy the book -- http://www.oreilly.com/catalog/perlhks/ Perl and CGI -- http://users.easystreet.com/ovid/cgi_course/ ------------------------------------------------------------------------- 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
