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)?
A simple syntax could be:
distributed_keys =
--- 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)?
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
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
--- 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
--- David Naughton [EMAIL PROTECTED] wrote:
http://www.hughdarwen.freeola.com/TheThirdManifesto.web/Missing-info-without-nulls.pdf
http://tinyurl.com/ytzeyd
I get a 404 for both of these. Mistyped URLs, or are they really no
longer available?
Grr ... I copied those from an old post. It
--- Jonathan Vanasco [EMAIL PROTECTED] wrote:
Upgrade to 5.x and turn on 'STRICT MODE' or SQL STANDARD mode - one
or both of those settings will fix that.
I wish :(
you could also move to postgres
I doubly wish :(
the distributed key system just looks like a version of table
On Mon, Apr 23, 2007 at 09:11:14AM -0700, Ovid wrote:
--- David Naughton [EMAIL PROTECTED] wrote:
http://www.hughdarwen.freeola.com/TheThirdManifesto.web/Missing-info-without-nulls.pdf
http://tinyurl.com/ytzeyd
I get a 404 for both of these. Mistyped URLs, or are they really no