Re: Date and McGoveran comments on view updating 'problem'
From: paul c <toledobythesea_at_oohay.ac>
Date: Mon, 08 Dec 2008 23:16:23 GMT
Message-ID: <bVh%k.3671$si6.1845_at_edtnps83>
Date: Mon, 08 Dec 2008 23:16:23 GMT
Message-ID: <bVh%k.3671$si6.1845_at_edtnps83>
paul c wrote:
> ... so I wonder
> what happens with "delete" to JOIN (which I believe is the operation
> that many people find controversial)?
> ...
Just as they find "insert" to UNION. The main argument seems to be that the operation is not deterministic when trying to decide on a base table by base table basis what to change, ie., there are three combinations of base values that could produce the same tuple in a view. McGoveran seemed to be saying that this argument is the wrong one, doesn't take in all available information because it manipulates extensions without concern as to the implications of the predicates and values involved before the insert or delete is tried.