Re: pointer to feature comparisons, please

On Thu, 14 Jun 2007 00:09:20 +0200, Ron Johnson <ron.l.johnson@cox.net>
wrote:

> On 06/13/07 16:59, PFC wrote:
>>> Isn't it *supposed* to mis UNcommitted changes from other transactions?
>>      Well, if the "uncommited change" is a DELETE of the row that
>> allowed the constraint check to pass, then when this delete is
>> commited, your data is no longer consistent.
>
> The DELETE should block, no?

    Why ?

    Foreign keys put an ON DELETE trigger on the referenced table besides
checking the referencing column on insert/update... If you just implement
a constraint, you only get half the functionality.