Subject Re: [firebird-support] Re: Poor selectivity in foreign keys
Author Ann W. Harrison

>But I agree, greater availability of the 'magic' would be useful.
>Even if it is slow.

My guess is that the application developer has a pretty good idea
which parent tables are stable - provinces in Canada - and which
are not. [Overly political parallel to states in the US after
this election suppressed.]

>What about deferring all RI checking to the commit point? That would
>remove the need for magic, and allow custom RI too.

Deferred constraints would be a good thing, I think, but they
are no panacea. Your data entry clerk wants to know that Onnterio
is not a province sooner rather than later.