Subject Re: [firebird-support] Isolation level in CHECKs and triggers
Author Ann Harrison
Jerome,

>What do you mean by "table constraints" ? CHECKs defined at the table level
>?
>I've played with some select-form CHECKs, and it seems they run in the
>*current* tx context unlike other constraints.
>
Sorry, I may have been generalizing without enough information. The
select form checks should run in system context (my opinion, like
everything else I write). They were implemented during the years I was
away from the project and their developer may have decided differently.
Or may not have thought about the problem. If it were up to me, I'd fix
that in future versions. Such a change should have no effect on
running programs or existing databases and will avoid a small chance of
inconsistency creeping into the database and breaking the gbak restore.

Regards,


Ann