Subject Re: [firebird-support] Re: Locking tables
Author Ann W. Harrison
Ann W. Harrison wrote:
> I'd have triggers on the reservations table ....

Thinking about it a bit more, I'd use gateway approach - relying purely
on triggers leaves the possibility of undetected simultaneous
inserts/updates that would not be detected.

The update of the gateway records should be in the same transaction as
the insert/update of the reservation records.