Subject Re: [Firebird-Architect] REPLACE statement
Author Adriano dos Santos Fernandes
Dmitry Yemanov wrote:
> "Adriano dos Santos Fernandes" <adrianosf@...> wrote:
>
>> Don't you think we can implement MERGE with already existing verbs, i.e.
>> blr_for, blr_store, blr_modify, blr_leave
>>
>
> Yes, we can. And we could also implement REPLACE using the existing BLR
> verbs.
>
I think no.
We don't store dependencies in backups, so a new verb is required to
catch the dependency on the constraint.
>
>> Or do you think we should generate the RSE (constructed based on the PK)
>> in BLR even for REPLACE?
>>
>
> This is questionable. I would do it this way (construct the PK references in
> DSQL), but your suggestion about a new BLR code and engine-level handling
> also looks good. I really don't know what's better.
>
I prefer the engine-level handling, although it's require more studies
from my side. :-)


Adriano