Re: Trigger Question
From: Joerg Leute <leute_at_itdesign.de>
Date: Sat, 26 Jun 1999 19:54:12 +0200
Message-ID: <7l341r$147g$1_at_news.lf.net>
Date: Sat, 26 Jun 1999 19:54:12 +0200
Message-ID: <7l341r$147g$1_at_news.lf.net>
[Quoted] True, but if you use the trigger to lock Table1, count it and then insert it into the other one would work
LOCK TABLE TABLE IN EXCLUSIVE MODE NOWAIT;
Count...... Insert...... Unlock it.....
>This is harder then it sounds. In a multi-user environment you will have
some
>issues unless you serialize access to table A based on your 'criteria'. If
you
>let 2 people simultaneously insert into A rows that match that
'criteria' --
>neither will see eachothers insert and may come to erroneous conclusions.
>
>See
>
Received on Sat Jun 26 1999 - 19:54:12 CEST