Subject | Re: [firebird-support] Isolation level in CHECKs and triggers |
---|---|
Author | Ann Harrison |
Post date | 2003-11-26T17:54:57Z |
Jerome,
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
>What do you mean by "table constraints" ? CHECKs defined at the table levelSorry, I may have been generalizing without enough information. The
>?
>I've played with some select-form CHECKs, and it seems they run in the
>*current* tx context unlike other constraints.
>
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