John,

> PS. Now I've learned that CHECK constraints can contain select's, I
> only want CHECK's to be able to dirty-read! Forget triggers.

FYI, here's what Ann told me in an old thread :

<quote>

>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

</quote>

I think I'd like triggers to be able to dirty-read too cause CHECKs
constraints won't fire in case of deletions.


Regards.

--
Jerome